>>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!