>>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