Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can anybody explain this behavior of cursoradapter ?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00777389
Message ID:
00777641
Views:
17
>>Should each cursoradapter object have its private connection handle ?
>When several CursorAdapter objects share the same ODBC connection/statement handle, CursorFill for some of them may fail because another CursorAdapter haven't finished fetch. To workaround this problem set FetchSize=-1 for all CursorAdapter objects or use dedicated ODBC connection/statement handle for each of them. I personally prefer the second.

Hi Aleksey
I set FetchSize=-1 for all CursorAdapter objects and now the form work as I expected. Thanks!
I am curious why you prefer second method (dedicated ODBC connections).
For me the method has two seriuos disadvantages:
- it is not comfortable in case when several cursors participate in the same transaction (you have to bind conections using token)
- it seems that form with many cursor will consume more SQLServer resources than it is needed (I wonder if it could cause exceeding MSDE limits).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform