>Before you can the CursorSource property, you have to CloseTables(). If you are doing this in a Form, it should be done in the Form's Load Event. You may want to create an abstract method in you base Form class called something like
LoadCursors and then call it from the Form's Load Event.
Closing and re-opening tables decreases the speed.
I see no reason why I can't set cursorsource property in the BeforeOpenTables!
In design time, I have only one company data located in directory
comp1 and form designer sets the cursorsource to this directory.
This directory contains many free tables.
In run time, I have separate directories for each company:
comp1, comp2, comp3 etc.
I prompt the user for a company number and then change all
cursorsources to this directory in BeforeOpenTables.
Why isn't this reasonable and I why I must use Load event?
>The BeforeOpenTables Event actually fires
during OpenTables() and is kinda tricky to do anything with.
What does this mean!?
I have no Opentables event, I use autoopentables=.t.
and nodataonload=.t. for views always.
Do you want to say that BeforeOpenTables executes between auto-opened
tables !?
I put the command "list stat to file t" in beforeopentables and
this sowhs that no tables are opened.
Andrus