Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rem. views Synchronous vs Asynchronouse
Message
From
12/10/1999 02:59:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rem. views Synchronous vs Asynchronouse
Miscellaneous
Thread ID:
00275305
Message ID:
00275305
Views:
71
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.
Next
Reply
Map
View

Click here to load this message in the networking platform