>>>Our application needs to switch DBCs for different data sets. The
>>>structure for each is the same but the data is different. Our form Data Environment is tied to the name of the DBC. I have tried setting the name of the desired DBC in the DE method - before tables are opened, but to no avail. (I used set database to ...)
>>>
>>>What is the best way to overcome this? I could ask the DE not to open/close the tables and open them explicitly, but would prefer to let the DE do its work if there is a simpler approach. It would be preferable if I could set the database once at the beginning of the application.
>>>
>>>Thanks much,
>>>Nancy
>>
>>The generic idea is following:
>>*** DE.BeforeOpenTables event
>>Local cDatabasepath
>>cDatabasepath=config.datapath && some configuration table setting
>>Thisform(set).SetAll("Database",cDatabasepath,"Cursor")
>>Note: it will work if all DE tables are part of DBC. If you have free tables you should check for them, and reset Cusros.Cursorsource properties.
>
>
>Thank you for this information. It worked great!

BTW, it's answer for one (or maybe two:) of Mr. Mendenhall questions.