Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE SQL - A way to see if update occurred
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00066044
Message ID:
00066053
Views:
27
>>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!
Previous
Reply
Map
View

Click here to load this message in the networking platform