Thanks Aleksey ! I will not drill down this subject. Now I know much more and must rethink my design in peace of mind.
Today I saw great message from Ken Levy that there is a special focus issue of CoDe Magazine on VFP 8.0 which Microsoft subsidized to have created. First article that I will read will be of course "Introducing the CursorAdapter Class"


>
>Jim's example uses dedicated ODBC statement handle. That is why it requires shared connection, SQLConnect( this.Parent.datasource ) obtains new statement handle for existing connection and it should fail if this.Parent.datasource doesn't represent shared connection.
>Looks like your form shares the same statement handle between all CursorAdapters, it should work fine with FetchSize=-1 regardless whether connection is shared or not.
>