Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to fix connection is busy error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00977596
Message ID:
00977670
Vues:
33
>I want to edit remote view in grid, saving changes for each record.
>Remote view returns large number of records so I use asynchronous fetching.
>
>However, if record needs to be updated, "Connection is busy" error occurs.
>
>I tried to set view MaxRecords property to 100, but does not allow to retrieve next 100 records.
>
>How to fix this issue ?
>
>Is it possible to fetch more that MaxRecords records in remote view ?
>Is it possible to update view using another connection ?
>Is there any other solution ?
>Any idea or code sample ?

You could try playing with the FetchSize and FetchAsNeeded properties. One thing that I've found that works in this case is a GOTO BOTTOM before any other commands. Of course, that could take a while on a really large table.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform