Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update T-Sql
Message
De
15/12/2004 09:47:45
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Update T-Sql
Divers
Thread ID:
00969429
Message ID:
00969429
Vues:
63
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
Répondre
Fil
Voir

Click here to load this message in the networking platform