Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving Data From a View or a Grid to a Table
Message
 
To
16/08/1998 19:57:07
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00127271
Message ID:
00127281
Views:
35
>I have a view from a table with a blank column for meter readings. I am using a grid to put the meter readings into the blank fields. I want to append the data from the view to a different table.

If you're planning to append the data as new records in a table, then either INSERT or APPEND will do. Use the RecordSource of the grid, and SCAN it (or use a do while loop if it's faster) adding the data one record at a time if any field needs to be changed. If it's just a matter of adding all data in cursor/view/table A to table B, use APPEND FROM.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform