| To assign a value to a field [message #288317] |
Mon, 17 December 2007 01:12  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
