Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement