Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating multiple tables in Page Frames in VFP 3.0
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00043621
Message ID:
00043833
Views:
46
>>I have a designed a page frame each page of which captures data for a different table. I want to use a single set of command buttons for this page frame also. How do you save multiple records to multiple tables ??? Since this form will run in a multiuser environment I am using record level optimistic buffering. I have created a SAVE button and in it's "click" method I tried using the following function calls to save the records:
>> TABLEUPDATE(table1)
>> TABLEUPDATE(table2)
>> TABLEUPDATE(table3).
>> When I execute this SAVE event I get an error message to the effect that VFP can't find the table alias. Is there a special syntax for databased tables ? Or am I barking up the wrong tree with this approach for saving multiple records in a page frame.
>>
>>Thanks for your answers !
>
>On which table are you getting the error? I found that it works better if you go ahead and select the table, then issue the update.

Gordon, is this the actual code? If so, you need to check the syntax:

TABLEUPDATE(.t., .t., 'table1')

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

Click here to load this message in the networking platform