Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to implement FetchAsNeeded
Message
From
30/07/2003 08:41:56
 
 
To
30/07/2003 02:07:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00814414
Message ID:
00814867
Views:
10
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
Previous
Reply
Map
View

Click here to load this message in the networking platform