SQL question

[skc]

Hi,

I am using FP2000 with an Access backend and I have
created a system that allows a user to call up a record
from a table, amend the record (amend the text box fields)
and re-save the record. If the text box fields for each
fieldname has been filled in and differs from the original
data then it must be saved.

Is there an SQL syntax that looks at the current record in
the table, if the submitted fields are different then only
those fields are changed?

I am doing this throught DRW using custom SQL.

Thanks,

skc

 

[Bob Lehmann]

It would be more efficient to just update the record whether it had changed
or not.

Bob Lehmann