Home » Developer & Programmer » Forms » To assign a value to a field
To assign a value to a field [message #288317] Mon, 17 December 2007 01:12 Go to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi all

I have a table name and column name in one table which was updated last time... When i query the record, i need to set the old value to the same table name and column name...

Eg:- Consider in table gn_update there is two columns named table_name and column_name which is updated last time and some more columns... When i query a form, if in cursor i found tht the same table which i am querying is in gn_update table, i have to show this in my form...(old value) i will get the table_name and column_name from the columns...and old_value and new_value from the gn_update table... How to assign the old_value to form...Even if i get all values in the variables in a cursor i couldn't assign it the the field... Did anyone understand my question...? As the form (the table which i am querying) contains a lot of columns i need to do this in few steps...can anyone help....

Thanks and regards
Sinida
Re: To assign a value to a field [message #288378 is a reply to message #288317] Mon, 17 December 2007 05:10 Go to previous messageGo to next message
timor
Messages: 12
Registered: December 2007
Location: egypt
Junior Member
dear
i don't understand you
but i do the same thing for security
i made a trigger to keep the old value and the new value and the operator
if u mean this just tell me and i'll send you the trigger
bye
Re: To assign a value to a field [message #288523 is a reply to message #288378] Mon, 17 December 2007 22:39 Go to previous message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi
Thanks for your reply. That problem got corrected. I used copy() fuction. I was not aware of this function. Thanks a lot.

Regards,
Sinida
Previous Topic: dynamic tabular form generate
Next Topic: Customized Master-Detail Form
Goto Forum:
  


Current Time: Sat Dec 03 10:06:51 CST 2016

Total time taken to generate the page: 0.04154 seconds