Help - Validation/Field rules

[Playball335]

I was someone could help me out as this is driving crazy.

If memory serves me correctly in A4 I could have a field rule applied to 1 set, but in another set it would not be set.

In A5 once a field rule is set on a field it permeates all sets that contain the table. Here is where my problem lies.

I have a customer table that is in a customer set that also contains a contract database linked by customer number. When I try to set a validation rule for any contract entered must require the contract number be filled, when viewing or entering a record in my inventory database (I have a browse that lists any contracts that an inventory item is part of) and there are no contracts on an inventory item the system yells at me that the contract number field is required even though this form is based on an inventory1 set.

Same thing happens with my service ticket database when no service tickets exist for an inventory item yet.

Any help would be greatly appreciated.

Thanks,

Travis

[Stan Mathews]

Re: Help - Validation/Field rules

You might want to consider having form level validation rather than table level validation. IOW you can code the candepart event for a field on a form and deny exiting the field until the field is filled or you could delete the current record if the user chooses not to proceed.

[Playball335]

Re: Help - Validation/Field rules

Thank you for your help.

Could you help me with setting up the form validation? Is this done with Xbasic? If so I am not advanced enough to write the proper code to accomplish the task at hand.

Thanks again.

[Stan Mathews]

Re: Help - Validation/Field rules

Thank you for your help.

Could you help me with setting up the form validation? Is this done with Xbasic? If so I am not advanced enough to write the proper code to accomplish the task at hand.

Thanks again.

Shouldn't be difficult, though it is xbasic, if you know what you want.

Maybe even easier than my previous suggestion might be to code the form cansave event. Can you outline the possibilities that would occur during data entry?

[Playball335]

Re: Help - Validation/Field rules

The validation I need in this case would be that the "Ticket Number" field must be 9 digits, no more, no less.

The other validation I was looking for in the contract entry form is that the contract number be required.

Thanks,

Travis

[Stan Mathews]

Re: Help - Validation/Field rules

The validation I need in this case would be that the "Ticket Number" field must be 9 digits, no more, no less.

The other validation I was looking for in the contract entry form is that the contract number be required.

Thanks,

Travis

there are other considerations but here is an example of what you requested.

[Playball335]

Re: Help - Validation/Field rules

Thanks Stan, it works like a charm. :)

However, I am trying to use the same method for a field in a tabbed form browse and it works until I try to leave the tabbed form browse then reports and error, after I click ok everything is fine. Should I add a statement when working within a tabbed form browse.

[Playball335]

Re: Help - Validation/Field rules

Stan,

Still having trouble with error reporting that the field does not exist.

Let me explain the scenario of how the form is set up.

The form is based on a workorders set that has a work orders parent and a child of assigned tickets.

The form itself contains work order detail, but on a tabbed form has a browse to easily add/delete tickets as engineers complete jobs against said work orders.

My problem is that I need to make sure that..

a) Users are required to enter a 9 digit ticket number
b) That when finished entering a ticket and a user clicks to another record the browse doesn't add a new record inadvertently to the assigned tickets database because the cursor was left in the browse.

Thanks again.

[Stan Mathews]

Re: Help - Validation/Field rules

Thanks Stan, it works like a charm. :)

However, I am trying to use the same method for a field in a tabbed form browse and it works until I try to leave the tabbed form browse then reports and error, after I click ok everything is fine. Should I add a statement when working within a tabbed form browse.

"works until I try to leave the tabbed form browse then reports and error" - and what might that error be?

I'm not at all certain what a "tabbed form browse" is. There are tabbed objects, which may contain browses. When you reference a field in a browse you must include the "path" that would tell Alpha how to find it. Something like

Main:browse1:tick_num.value

additionally there is no candepart event for a field in a browse so you have to settle for the candepart event of the browse itself, validate the values, and send the user back to the appropriate fields as necessary.

Something like

if len(alltrim(Main:browse1:tick_num.value))<> 9
	cancel()
	ui_msg_box("Sorry","Must be exactly 9 digits.")
        Main:browse1:tick_num.activate()
end if

[Playball335]

Re: Help - Validation/Field rules

I'm sorry, I am referring to a browse found on a tab.

The error I receive is that it cannot find the ticket_no field.

The "Main:" portion of your code, does that refer to the form name or the table the field is found in?

After trying your latest code, here is the error I receive.

Script:: Work_Order_Entry:TICKENT.CanDepart Line:5
if len(alltrim(Work_Order_Entry:TICKENT:ticket_no.value))<> 9
not found

Work_Order_Entry:TICKENT:ticket_no not found

[Stan Mathews]

Re: Help - Validation/Field rules

I'm sorry, I am referring to a browse found on a tab.

The error I receive is that it cannot find the ticket_no field.

The "Main:" portion of your code, does that refer to the form name or the table the field is found in?

After trying your latest code, here is the error I receive.

Script:: Work_Order_Entry:TICKENT.CanDepart Line:5
if len(alltrim(Work_Order_Entry:TICKENT:ticket_no.value))<> 9
not found

Work_Order_Entry:TICKENT:ticket_no not found

Main is the name of my form. What is TICKENT in your form?
Right click on the browse on the tab and check its properties, object name. Probably will be browse1 unless you changed it or have more than one.

[Al Buchholz]

Re: Help - Validation/Field rules

Travis

You may find some help with the naming by using the object explorer.

In design mode - view - object explorer

[Playball335]

Re: Help - Validation/Field rules

Main is the name of my form. What is TICKENT in your form?
Right click on the browse on the tab and check its properties, object name. Probably will be browse1 unless you changed it or have more than one.

TICKENT is the name of the browse.

[Playball335]

Re: Help - Validation/Field rules

Here is a screenshot of the form/browse along with the explorer detail.

[Stan Mathews]

Re: Help - Validation/Field rules

Here is a screenshot of the form/browse along with the explorer detail.

I think the picture shows that the line should be

Work_Order_Entry:TICKENT:ticket_no_.value

At least that (ticket_no_) is the way the object name appears there.