Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to update local views ?
Message
 
À
21/04/2000 21:15:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00362432
Message ID:
00362433
Vues:
18
>I am trying to work with local views. I have defined the view using wizard. In the update criteria I have choosed send SQL updates, update using SQL UPDATE and key and modified fields.
>
>How to update local views? Must I use the same commands to update local tables like insert, replace and tableupdate or must I defined a Connection?
>
>The updates made in local views are sent automatically to local tables?

You must think if you want buffered tables (IMHO they should be with buffermode 5). For updating issue a TABLEUPDATE, with this all will be saved into your table.

Also consider doing transactions, for protecting your updates in a "all not not change".
Pablo Roca
Clavo Congelados, S.A. (La Coruna - Spain)
Sysop of PortalFox

Join MasFoxPro campaign
http://www.masfoxpro.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform