Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can anybody explain this behavior of cursoradapter ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00777389
Message ID:
00777641
Vues:
18
>>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).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform