Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SPT Update Solution
Message
De
26/09/2005 10:57:10
 
 
À
26/09/2005 10:45:19
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01053058
Message ID:
01053067
Vues:
13
>I have a grid based on a SPT cursor. I would like to use this grid to make changes and then do a SPT update to save my changes to the remote table.
>
>The way I currently handle this is make a change on a single record, run the update code, then proceed to next record. There must be a way to make all my changes with on update command.
>
>Would I scan through the select cursor of the grid data, making an update on each record?


See "How to make SQL Pass-Through cursor updatable" FAQ #8153.
Then just issue TableUpdate(.......)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform