I have been finding some interesting things.

When I use SQLEXEC() w/ ODBC to get remote data, it doesn't return control until the cursor has been filled with the data. that is what i have expected.

However, when I use a CursorAdapter w/ ODBC, once the CursorFill method has fired, i have control back. However the data file is still not filled with data. This is a problem.

I checked the Asynchronous to my connection in both SQLEXEC & CursorAdapter, they both return .F.

One other thing I noticed is that when i use SQLEXEC, i get a wait window telling me it is Executing remote...press ESC to cancel. With the cursor adapter, i can just start typing the the command window my next command.


any help with this would help.

Thanks.