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

Click here to load this message in the networking platform