>>>>>I'm deloping apps on a network. The production version of these apps are looking for data on the development drive. How do I change the path that the Form's Data Environment looks for the data?
>>>>
>>>>Add code in Dataenvironment.BeforeOpenTables event
>>>>local cDbcpathname
>>>>select config && this is configuration table
>>>>go top
>>>>cDbcpathname=alltrim(config.dbcpname)
>>>>thisformset.setall("database",cDbcpathname,"cursor")
>>>>You can use this code if all DE.cursors are for dbc-tables. If you have free tables then you should modify this code to reset CursorSource properties.
>>>
>>>
>>>Is there a way to change the location of the DBC properties in the same way?
>>
>>Sorry, I don't understand exactly what you mean. The only place in app which points to DBC file is DataEnvironment.Database properties, and the abovementioned code will reset it.
>
>
>I'm referring to the DBSETPROP() command. Is it good practice to change the location of the DBC and the location of the related tables in the DBC in the main program of the app.
DBSETPROP() is not for this purpose.
Edward Pikman
Independent Consultant