Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update T-Sql
Message
From
15/12/2004 09:47:45
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Update T-Sql
Miscellaneous
Thread ID:
00969429
Message ID:
00969429
Views:
62
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
Map
View

Click here to load this message in the networking platform