Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pack Problem - File must be open exclusively
Message
 
 
À
05/08/2005 00:33:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01038783
Message ID:
01038811
Vues:
16
>Thanks Sergey:
>
>But whats the best solution for what I need to do. I need to set up a tempary table, have the end user enter the data, review it and then append it to the main contribution table once they feel the data is correct.
>
>I thought that the bext way would be to fill a temporay table, then append from that table and delete the fields for the next entry.
>
>I am coming from an access background so I guess my though patterns are way off.

Jimmy,

Don't try to do stuff in VFP the way you used to do in Access. You would get nothing but frustration because VFP is quite different. VFP's not less capable but different.
There're very few cases in VFP where you would use a temporary table because VFP has cursors. It's basicly the same temporary table but VFP automaticaly deletes it after it's closed. You can create a cursor with CREATE CURSOR command, SELECT ... INTO CURSOR READWRITE and other ways. Because cursor is unique to the running application, you don't have to worry about conflicts with other users. You cannot use PACK on a cursor but you can empty it with ZAP command.
You can also use a parameterized view in the table buffering mode. Issuing Tableupdate will save records to the underlined table. Tablerevert will kill changes.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform