Omar
|
| Posted: 02/27/2002, 12:28 PM |
|
I have a form that updates statuses, if the value of current staus Less than the new status, then I am ok.
the question is if i the user is tying to update record with a status with a value Less than the current status I wnat the higher value status to apply.
simply put current shipment status = deleivered (Value= 80), and
new shipment status = Cargo_Delayed (value=50)
I want the higher value to remain in the record, and let the user know that status in invalid
|
|
|
 |
Alex Alexapolsky
|
| Posted: 02/28/2002, 1:50 AM |
|
This is where you should use Validation event.
Field variable are avail via fld prefix , e.g. fldstatus.
If you detect validation error , then assign error text to s[FormName]Err
variable , CC will check this variable and won't update form as this var is not
empty.
|
|
|
|
Omar
|
| Posted: 02/28/2002, 7:27 AM |
|
Ok! But how do I get the last value of the record that was updated, is it something like max(somthing), and if it is can you please jot down the statements, or the syntax.
|
|
|
|
|
