>Hi.
>I have database in the directory C:\MyProgram\DBF\
>I make a copy of the directory with files C:\MyProgram\ARHIV\
>
>After that I want dynamically to use one of databases...
>In Main.PRG there is a reference to path SET PATH TO DBF;.....
>At connection of archive I replace SET PATH on SET PATH TO ARHIV..
>
>lcArhiveDatabase = FULLPATH (SYS (2003)) + '\ARHIV\MyDBC.DBC '
>OPEN DATABASE &lcArhiveDatabase SHARED
>
>After that I start the form... And... In it there are data from C:\MyProgram\DBF: ((
>I think that it result of Dataenvironment.Cursor.Database in the form = " C:\MyProgram\DBF\myDBC.DBC"....
>What it is possible to make?
>Thanks.
>Denis Gavrikov.
Basically, you don't need in SET PATH at all. Instead of this you keep actual data location locally (e.g. in config.dbf) and reset programmatically DE.Cursor.Database property in DE.BeforeOpenTables event(s).
Edward Pikman
Independent Consultant