General information
Forum:
Microsoft SQL Server
I have looked on the BOL, and it looks like the only way to update a record is to do the specific field by field set command.
I was hoping there was a simple Update, like the Insert values(list of values).
Is there anything that can do this?
My VFP program gets passed a string that is one of three items, a new record, an update to a record, or a record to be deleted. I have been doing if it is an update, I delete the record and Insert the changes as a new record. This does not work with PKs and FKs. I am using SPT.
Is there any way to do an Update without the field by field?
Thanks,
Beth
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only