You will have to use the Update Type "key and changed fields" -- so if your update SQL fails, you know you have to go back and try again.

Hank

>Hi all,
>
>we have a small prg in VFP that generates a key from a table, works perfectly in VFP. I'm now starting to work in .Net and need to get the net available number in the table and replace the existing number with original + 1. The table that stores the keys is a frequently used VFP table so I do need locking in order to ensure that I don't duplicate keys.
>How do I go about this via C# in .Net?
>
>~M