>>>I have a project which controls our orders season wise, for eg.
>>>
>>>Fall 98
>>>Spring 98
>>>
>>>Fall 97
>>>Spring 97
>>>
>>>Now the structure of main dbf files for the particular season are same, only data is changed..
>>>
>>>I want to setup one main program which consists subdirectiories for the season...
>>>
>>>Like
>>>
>>>c:\mainprog
>>>c:\mainprog\fall98
>>>c:\mainprog\spr98
>>>
>>>& from the software itself it should change the seasons that means, suppose a user selected spr98, all my forms, should load data from that dir...
>>>
>>>My questions are :-
>>>1. How I can do it ??
>>>2. Whether I'll need multiple dbc files or one is enough.
>>>3. Some of the files are common also like setup.dbf, which should always load from the main dir. from where software is running, How software is going to handle that..
>>>
>>>Any Ideas/Suggestions ??
>>Hi,
>>- You could use filter and/or views instead of subdirs.
>>- You could use subdirs as you suggested. If you use multiple dbfs then you would need only one dbc but this would need extra coding loading DE and as years pass many tables would be added to the same DBC.
>>- One DBC and one DBF method is more sense. All you need is to have a copy of the DBC also in subdir. In this case after user selects season you would change your data path with *set path*. This way AppDir need not be changed.
>>ie:
>>public cOld_Path
>>cOld_Path = set("path") && Path without data.
>>..
>>* User selection of SEASON
>>set path to cOld_path + ";" + cSeasonPath
>>Cetin
>
>Thanks for your reply !!! Your suggestion is very useful...
>
>But I'm facing few problems in setting it up...
>
>If I just set the path to my season dir.. it opens file from the dir. where I'm developing the application...
>
>I guess this is because the thisform.dataenvironment.cursor1.database value is set to my application development dir...
>
>Now what I'm doing is Opening the form with Autoopentables=.f.
>
>In the load method of form, I'm setting the value of
>
>thisform.dataenvironment.cursor1.database=myseasondir
>
>& then running Opentables...
>
>Pls tell me :-
>
>1. Am I doing it right way or is there any shortcut..
>2. If my method is right, Is there any generic routine which can loop through all the cursors and set the value...
>3. How I should handle Tables which are common that means dbfs which are having common value for the software.. like setup.dbf..
>
>Pls help...
You could use ODBC to access your database (DBC) and set your data source to the different directory as needed.
Wayne