| forms and databse call in it [message #414832] |
Thu, 23 July 2009 13:48  |
cool_coder
Messages: 17
Registered: September 2008
|
Junior Member |
|
|
Hi,
I am having one issue in executing forms.
This form/application screen has couple of field. Say A_DATE B_DATE.
there is a check in place to take care of condition that B_DATE is always > A_DATE. and if A_date is changed by user b_date is getting calculated.(these items are based of databse table).
However , issue comes because of one scenario when A_date is changed by database function (after geting called by a featuree) and which overrides the above condition.
To take care of this scenario , i put a message to ask user to change A_date so that B_date gets recalculated..and it does happens on the screen..BUT right after this, a database-function call is there in that form-trigger ..which gets old values from
table and updates back the B_date.
What should be done to update the values in databse just befor calling d/b function...
is calling_block and execute qry is correct or any other idea?
thanks
|
|
|
|
| Re: forms and databse call in it [message #414895 is a reply to message #414832] |
Thu, 23 July 2009 23:47  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
You say "if A_date is changed by user b_date is getting calculated". Call this routine again after the code that "one scenario when A_date is changed by database function".
Why are you getting the old information from the database?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
