| how check value befor commit [message #168762] |
Sat, 22 April 2006 04:44  |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
hi master
sir
how check value befor commit my form if that value right than commit otherwise show message box and not save
please give me idea
thanking you
aamir
|
|
|
|
|
|
| Re: how check value befor commit [message #168854 is a reply to message #168768] |
Sun, 23 April 2006 19:33  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Personally, I think that the Key_commit trigger is far too late to be doing most validation. There are two VERY important triggers, When-Validate-Item and When-Validate-Record, and it is in these triggers that you should be doing ALL your item and record level validations. This becomes critical if you follow normal practice and do NOT do your commits row by row, but a block at a time as Oracle Forms was intended. Remember you are using software that is designed to use your network efficiently, don't muck it up by accessing the Application Server and database for every row when you can do the work and only access the AS and DB every 10 or more rows.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
