>>>>There is almost nothing that can't be done with VFP :-)
>>>>But when you on the way to convert your application from VFP NATIVE database to some other back end, I don't think that opening the table before invoke CA CursorFill() method is the way to go. This is just my opinion of course.
>>>>
>>>
>>>Any particular reasons?
>>>
>>>Thanks,
>>>Aleksey.
>>
>>Yes,
>>If I want to move to SQL Server, but have no time to convert all my forms I will prefer to use ADO recordset or ODBC one (not for VFP 9 tables) when I build CA, just to make sure that I won't miss something.If I must use the table before CursorFill() method what will happens with my form where I have a 20-30 tables opened? Also when I finish convert I must go through all my form and remove all code where I open my tables. This can be done in CA class, but after finishing conversion I mus remove that code from my class.
>>
>
>What is the answer to the question: "If I must use the table before CursorFill() method what will happens with my form where I have a 20-30 tables opened?" What exactly will happen?
>
>Thanks,
>Aleksey.

In BeforeOpenTables of the form I must have:

USE MyNatoveVFPTable1 ALIAS SomeAliasThatCAWillExpect1 IN 0
USE MyNatoveVFPTable2 ALIAS SomeAliasThatCAWillExpect2 IN 0
USE MyNatoveVFPTable3 ALIAS SomeAliasThatCAWillExpect3 IN 0
....
USE MyNatoveVFPTable20 ALIAS SomeAliasThatCAWillExpect20 IN 0

Of course all this could be done in CA class, but what if I have some CA that get data from many tables and uses many joins?
Are you sure that using USE .... ALIAS and after that base CA to that Alias is easier way?