Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to implement FetchAsNeeded
Message
De
30/07/2003 02:07:54
 
 
À
29/07/2003 23:07:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00814414
Message ID:
00814809
Vues:
10
This message has been marked as the solution to the initial question of the thread.
>I have further questions regarding this feedback:
>
>>> Depending from backend, "AllowSimultaneousFetch" property must be set to .T. to allow second view to be opened while the first view has some records to fetch.
>
>1. Does this mean that I will not have the "Connection is busy" error if this is allowed by the backend database?
>

That is correct for shared connection. Potentially, some backend might allow to do simultaneous fetch without "AllowSimultaneousFetch"=.T., but Sql Server requires "AllowSimultaneousFetch"=.T..

>2. VFP Help states that: AllowSimultaneousFetch "Applies when using remote views, a shared connection, and to cursors created using ODBC. .T. - Permit similarly configured cursors sharing the connection to fetch rows simultaneously. "
>How do you define "similarly configured cursors"?

They use the same setting for "AllowSimultaneousFetch".

Thanks,
Aleksey.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform