Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to implement FetchAsNeeded
Message
De
30/07/2003 08:41:56
 
 
À
30/07/2003 02:07:54
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:
00814867
Vues:
11
Thank you. Very useful info here.

>>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.
ramil
~~ learning to stand still
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform