General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only