>>>>>>>>>>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.
>
>
>I need to modify this code to include both a DBC and free tables. I tried to use the AMEMBERS() command and put the properties and members of the Data Environment into an array. This obviously didn't work. Any suggestions?
>
>Thanks
You should go through all DE.Cursors checking Database property first, if it's empty then you reset Cursorsource property, if not- reset Database property itself.
Edward Pikman
Independent Consultant