Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to add data
Message
From
23/08/2004 04:36:39
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
 
 
To
20/08/2004 15:33:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00935012
Message ID:
00935477
Views:
22
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
Previous
Reply
Map
View

Click here to load this message in the networking platform