Home » Developer & Programmer » Forms » forms and databse call in it
forms and databse call in it [message #414832] Thu, 23 July 2009 13:48 Go to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Record orientation problem
Next Topic: navigation-in-enter-query-mode
Goto Forum:
  


Current Time: Thu Dec 08 22:23:21 CST 2016

Total time taken to generate the page: 0.07755 seconds