>>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
>Hi Nancy,
>This one is from thread #67659, Title-"Question abt. dataenvironment"
>

>* Dataenvironment.beforeopentables
>cNewDataPath = _screen.comment && or wherever stored
>set path to (cNewDataPath)
>nDataObjects = amembers(aMyArray,this,2)
>cOldPath = this.&aMyArray[1]..database
>cNewDbPath = cNewDataPath+substr(cOldPath,rat("\",cOldPath))
>for ix = 1 to nDataObjects
> if this.&aMyArray[ix]..baseclass = "Cursor"
> this.&aMyArray[ix]..database = cNewDbPath
> endif
>endfor
>
>Here is a way to change path at runtime using above :
>
>*Method processing user data path && Likely to be called instead of do form
>lparameters cNewDataPath, fForm
>_screen.comment=cNewDataPath && Instead of pub var - if !used to store something else like form instances
>do form (fForm)
>

>Cetin

Cetin, this method can bomb if you have free tables in DE.