What you say confirms my fears. Is there any way around this without going to Asyncronous mode?
The same thing happens in VFP7 with SPT so the Cursor Adapters by themselves are not wrong.
Is there anywhere where I can get more info about this darn fetchsize?
Is it a VFP problem or an ODBC problem?
This most certainly looks like a BUG, most noticable when the SQLServer dishes out the data for the first time. After that it ic cached and a bit faster.
Any ideas?
>Hi Bernard,
>
>On VFP the ODBC rows are fetched one by one.
>
>Then, if you use a ODBC in Syncronous mode,
>FetchSize is ignored,
>and, i think, it put 100 into the C variable
>for the fetch loop ( last line of this loop is the talk output).
>
>Because VFP not use ODBC Array advanced APIs,
>FetchSize in syncronous mode is irrelevant.
>
>Then FetchSize is usefull only on Async mode.
>
>Fabio