VFP60 <-> SQL65
I have a number of stored rem. views in an application.
All of the rem. views:
- use the same shared Synchronouse connection;
- have their Fetch Remote Data As Needed checkbox not ticked (FetchAsNeeded=.f.).
Initially the rem. views had their Number Of Records To Fetch At a Time = 100 (FetchSize=100). The problem was that when i consequetively opened the rem. views i received
Connection myconn Is Busy
error.
In order to eliminate the problem i had to FetchSize = -1. But AFAIK this property is only relevant to Asynchronous connections. Am i missing something?
And for that matter, what's the difference between stored rem. views using Synchronous and Asynchronous connections?
TIA.
A moment of silence is our cosmic reset button.