If you are proficient in TSQL and SQL Server, you could put this update into a stored procedure and return a value from that procedure to indicate update/no update. Then you would use SQLEXEC from VFP to call that procedure instead of the direct update.

>I am doing a Microsoft SQL update using SQLEXEC. The update statment is written in such a way as to update one record if the copy residing on SQL server has undergone no changes since downloads, or to update zero records if there has been such as change.
>
>My problem: Since this is an update rather than a select statement no SQLresult cursor is created. And since the syntax is right regardless of whether one or zero records are updated, the return value of SQLEXEC is always 1.
>
>So how do I tell whether zero o no records were updated after running the SQLEXEC statement?
>
>Thanks
>
>Gar