| how to code the update button in a form [message #80983] |
Sun, 22 December 2002 00:09  |
Aydah
Messages: 11
Registered: November 2002
|
Junior Member |
|
|
hi there,
I have created an update button, so when the user click on it , it will ask the user if he wants to update the form (yes or no), my problem is that I want the trigger to check if the user have made any changes if yes then I want to fire the update message. How can I do it?
|
|
|
|
| Re: how to code the update button in a form [message #80989 is a reply to message #80983] |
Sun, 22 December 2002 19:15  |
Evan Briggs
Messages: 12
Registered: November 2002
|
Junior Member |
|
|
There are system variables for block and form status that show whether the current form or block contains records that have been changed (See code below):
------------------------------------------------
IF (:SYSTEM.FORM_STATUS = 'CHANGED') THEN
MESSAGE ('THE FORM HAS BEEN CHANGED');
ELSE
MESSAGE ('THE FORM HAS NOT BEEN CHANGED');
END IF;
IF (:SYSTEM.BLOCK_STATUS = 'CHANGED') THEN
MESSAGE ('THE BLOCK HAS BEEN CHANGED');
ELSE
MESSAGE ('THE BLOCK HAS NOT BEEN CHANGED');
END IF;
------------------------------------------------
Lookup 'SYSTEM' in the Form Builder help files for more information.
Good luck, Merry Christmas.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
