Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rem. views Synchronous vs Asynchronouse
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Rem. views Synchronous vs Asynchronouse
Divers
Thread ID:
00275305
Message ID:
00275305
Vues:
70
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform