>>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.
>
>check the Share connections box in the view.

Victor

As i said "All of the rem. views:
- use the same shared Synchronouse connection;"
So they all have their Share Connection box checked. But this is not the question, what i would really like to know is the difference between stored rem. views using Synchronous and Asynchronous connections

Kamil