>>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
Thanks, I'll give it a try.
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!