Help - Validation/Field rules

[Playball335]

Re: Help - Validation/Field rules

Stan, that was it. One minor problem left.

Have I mentioned how much I appreciate your help? :-)

How would I allow the user to cancel out? Right now if I enter a ticket number of less than 9 char. it yells at me properly. However it won't let me cancel out of the record without having to enter a record.

Thanks once again.

[Stan Mathews]

Re: Help - Validation/Field rules

Stan, that was it. One minor problem left.

Have I mentioned how much I appreciate your help? :-)

How would I allow the user to cancel out? Right now if I enter a ticket number of less than 9 char. it yells at me properly. However it won't let me cancel out of the record without having to enter a record.

Thanks once again.

I may be wrong but I don't think that is doable. You get the warning when the user exits the browse, not when they change rows. What could happen is that the user enters an incorrect ticket, moves to another row, then exits the browse. At that point there is no way to tell which record should be deleted.

I suppose it would be possible to process all the child records and delete any with incorrect ticket numbers but a lot of work. Why not just have the users finish the entry with garbage and delete it when done?

[Playball335]

Re: Help - Validation/Field rules

What is happening works to a degree.

a user moves into the browse to add a ticket, realizes for instance they are in the wrong work order and want to escape. The CanDepart statement will not let them leave the record.

Is there anything I can do to let them escape without saving the record?

[MoGrace]

Re: Help - Validation/Field rules

Here's my 2 cents: Why not use the CanSaveRecord to test for a blank or invalid entry in the field and cancel the Save, then warn the user why his data was not saved? That will at least give him the opportunity to try again.

[jacobr]

Re: Help - Validation/Field rules

I'm not sure this thread is still active.
I've a journal entry screen with browse1. Columns in browse1 are ac_code, dr_amount, cr_amount.
If I enter a value in Dr_amount, cr_amount should become 0 and vice versa.
The code is something like this
if Dr_amount>0
cr_amount=0
endif
if cr_amount>0
dr_amount=0
endif
Where will I validate this? Please help

[Ray in Capetown]

Re: Help - Validation/Field rules

That creates a chicken or egg conundrum.
In a browse you work at a record level so which comes first?
Maybe when you start to edit a record you must zero both.
Common Dr/Cr practice does not use two amount fields - separation occurs in presentation.

[jacobr]

Re: Help - Validation/Field rules

I did manage to do this.

I've a journal entry screen with browse1. Columns in browse1 are ac_code, dr_amount, cr_amount.
If I enter a value in Dr_amount, Cr_Amount should become 0 and vice versa.
How?

Select Table - Design - Field rules
Select Dr_Amount-Events-Field Events-onWroteField

if gl_tran->Dr_Amount>0 then
gl_tran->Cr_amount=0
end if
Select Cr_Amount-Events-Field Events-onWroteField

if gl_tran->Cr_Amount>0 then
gl_tran->Dr_amount=0
end if

[jacobr]

Re: Help - Validation/Field rules

When I make a copy of a table I miss most of the field rules. I right click the table to copy then select duplicate.
Any suggestion on this?

[Al Buchholz]

Re: Help - Validation/Field rules

When I make a copy of a table I miss most of the field rules. I right click the table to copy then select duplicate.
Any suggestion on this?

Post a couple of images of what you do and the choices that are available. From your other posts, I'm guessing that you are using v10 or v11, not v7 like this forum is for..