Rich:
>My problem is: What is the easiest way I can check which variables have
>been changed. I would then update only the appropriate table / tables
>(Approx. 10 tables) that are affected. <
Okay I doubt this is easier programming wise but maybe someone else could
think of a way to do this... Would it be possible to load all the initial
variables into one column of a temp table, maybe even with 2 columns for
the
table & column that the variables refer to, then do a series of probably 39
update columns after the form to put the new values next to the old ones.
Then you can update where the old column <> new column, probably
dynamically
constructing the UPDATE statement as you go thru a cursor if you like.
It's technically cooler than doing 39 comparisons, but is it easier and
faster???
In case I was unclear, a temp table like this:
OldValue Table Column NewValue
hello Table1 Text1 hello
bye Table1 Text2 goodbye
Cursor thru the table where oldvalue <> newvalue, construct the
update statement using the table & column name in ampersand variables.
Worth trying?
Karen
