>>>>>>>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.
>
>
>
>This procedure works fine. How can you save this as an abstract custom method on a form?
You can have generic oApp method 'setdatabase'
***oApp.setdatabase
LParameter oForm
local cDbcpathname
select config && this is configuration table
go top
cDbcpathname=alltrim(config.dbcpname)
oForm.setall("database",cDbcpathname,"cursor")
return
Each form DE will call:
oApp.setdatabase(thisform)
Edward Pikman
Independent Consultant