>>>>>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.
Edward Pikman
Independent Consultant