Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL UPDATE - Does it include INSERT?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00066036
Message ID:
00066056
Views:
24
>>It seems that somewhere I read that the SQL Update command will do an INSERT simultaneously or vice-versa? Is that the case or is each command mutually exclusive?
>>
>>TIA,
>>
>>Bill
>
>For VFP, Update will not change any records if there are no records that match the where condition. On the other hand, insert *always* adds a new record. Therefore they are opposities in behavior.
>
>Peter

Makes sense. I don't know why I think I saw that one included the other. Oh well, thanks!
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform