>>>>>>I have a program in vfp50. One of the options in the program
>>>>>>allows to you change the data PATH. I have tested the code that
>>>>>>changes the data PATH and I have made sure the PATH is changed. I am using buffering with CURSORSERPROP(). After I change the data PATH, I refresh the screen, but the old data is still displayed. My code is:
>>>>>>
>>>>>>set path to &newpath
>>>>>>do form myform (init event)
>>>>>>select mytable
>>>>>>thisform.refresh
>>>>>>
>>>>>>Anybody know what the problem is?
>>>>>
>>>>>Data path is hard-coded in DataEnvironment, so, if you still have data files on this hard-coded path, you will get them regardless your PATH statements.
>>>>---
>>>>Hi Ed and thanks for your reply - OK - How do I put my files
>>>>in the DE and not hard code them so I can change the PATH?
>>>>Or is there another way to handle data files if one plans
>>>>to change paths on the program?
>>>
>>>You may change DE.Cursor.Database properties (for DBC-ed tables) and DE.Cursor.Cursorsource properties (for free tables) programmatically in run-time in DE.BeforeOpenTables event.
>>---
>>Thanks Ed... Would you please give me a small code sample.. you
>>know how slow I am... :)))
>
>****DE.BeforeOpenTables event
>LOCAL cDbcpathname
>SELECT config
>GO top
>cDbcpathname=alltrim(config.datadir) && e.g "G:\myfolder\mydata.dbc"
>thisform.setall("database",cDbcpathname,"cursor")
>This code will work only if you do not have free tables in your DE.
-----
OK - I will try it - thanks ... :)