>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.
Mark,
I haven't used the cursoradaptor myself yet, but try setting the following
FetchAsNeeded = .F.
FetchSize = -1
HTH,
Tracy