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:
00977832
Vues:
40
>>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.

I tried those properties but without success.
It seems that it not possible to cause REMOTE view to fetch more rows without
connection is busy error.

I also thied to increase MaxRecords property in runtime
DBSetProp('RKLIENT', 'View', 'MaxRecords', DBgetProp('RKLIENT', 'View', 'MaxRecords')+100)
and use REFRESH() function but this does not work without requery.

Fetching rows on demand is only possible using async fetching but this makes connection busy.
Andrus
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform