>>>I want to choose the path of the databases (3) in a form.
>>>
>>>In each local computer, I have a table who have: company, menu, directory
>>>
>>>In the main menu there is a form where the user can select the database of that company. (all databases have exactly the same structure but differents paths.
>>>
>>>When the users choice a conpany, I CLOSE ALL, send a PATH command with the database´s path, the forms,menus and rest of staff paths, and open the databases again
>>>
>>>I have all the forms EXCLUDED from the project
>>>
>>>The users have their private directory for temp files and indexes (I use CD "c:\temp" to do it).
>>>
>>>Sometimes, the views doesn´t work, others the program goes crazy with tables and databases....
>>>
>>>Am I wrong?
>>>
>>>Is there a better way to do it?
>>>
>>>thanks.
>>
>>The proven method is to reset Database property (using appropriate path) for all cursors in DataEnvironment.BeforeOpenTables event.
>
>Gott!!
>
>Does it means that the database property does not change if you change the database path?
>
If you open Scx file manually, you will see that Database properties embedded in as is (absolute path), therefore it's your responsibility to reset it to another value if necessary. Surely, if a form cannot find DE.Cursor.Database then it will use SET PATH setting, however it doesn't look as very reliable arrangement in real network.