Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to add data
Message
De
23/08/2004 04:36:39
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
 
 
À
20/08/2004 15:33:13
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
Divers
Thread ID:
00935012
Message ID:
00935477
Vues:
21
HiSteven,

See Buffering in VFP. You can use Table Buffering (pessimistic or optimistic) to prevent updating record everytime you move record pointer.
You need to add a save button to save the batch of record one time.
Saving your record should be in batch. Your code for for Save should be Tableupdate().

Hope this help.

Rene

have as part of my app a document creation module. The user will initiate the document by suppling a number. My app inserts this document number into a table. Then a form displays the new document with fields in upper portion of the form displaying the main document data. I have a grid on the form based on a view of another table which holds items used by the document, both tables are linked by document number. I have a button on the form with which I insert one record into the view, requery the grid source. The user can type in the document items in that record. Pressing the button again will add a second record and so forth. This is slow because of the updating the view every time a record is changed.

Is there a better way?
Thanks and May God Bless,
S. Dyke
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform