In the modal form, there are no tables in the Data Environment - it's using the default data session from the main form. So would the value of AutoOpenTables have any effect?

J
>Hi Jill, do you have AutoOpenTables and AutoCloseTables in the modal form set to .F.?, it should be, to keep it from messing things up.
>
>>[this may be a repost of a partial message sent earlier by mistake...if so, sorry about that.]
>>
>>I have data in a parent table, CSN (clients), and related records in ClientConditions (medical conditions). When a new client is entered, I want
>>to require at least one condition. I want to update the tables with views (table buffered).
>>
>>The main form updates CSN records. In another, modal form (w/default data session), called from the main form, the user chooses the entries for ClientConditions.
>>
>>So i have an UpdateCSN view and an UpdateClientConditions view. I wrap the updates in a transaction, updating UpdateCSN first, then UpdateClientConditions. The update of UpdateClientConditions fails (I've checked out the view in interactive mode and the update works fine).
>>
>>I can add more details, but I just found the following in the Hacker's Guide (under TableUpdate):
>>
>>"In later versions of VFP, failing to either commit or revert changes before closing a form is the same as reverting the changes."
>>
>>Does this mean that a tableRevert will be done when I exit the modal form and then when I do the transaction, the TableUpdate will fail for that reason?
>>
>>Obviously I'm confused. Input is appreciated.
>>
>>J