>Is there a command or flag you can check to see if an UPDATE command actually updated a record? If it didn't, I want to execute an INSERT command to append the record.
>
>TIA,
>
>Bill
Check the foxpro _tally variable after the update command has completed. This should tell you how many updates occured. As a rule of thumb, set _tally = 0 before you try the update.
Peter
Peter Stephens
Visual Records, Inc.
Lead Programmer for the general purpose record keeping system Visual Records. Written primarily in VFP 6.0 with a little C++.