>George,
>
>Interesting questions ;-) I have actually the exact same requirement for an application that I am working on. I really like Bob's idea of using a UNION and to check the record count.
>
>Unfortunately UPDATE_COLUMN() and UPDATE() functions return true even if the data has not been changed. It really depends how the update command has been specified. In VFP terms, any field in a remote view for which GETFLDSTATE() indicates that the field has been changed will cause UPDATE_COLUMN() to return true irrespective of the actual values.
Daniel,
Yes, I found that out about about both Updated() and COLUMNS_UPDATED(). Right now, I'm working with a basic table (3 fields) to see if I can get a solution similiar to BOb's working. Once I do, I'm going to use VFP to generate scripts and insert them via SQL-DMO.
Thanks for the feedback.
George
Ubi caritas et amor, deus ibi est