Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I usually do not have reason to use cursoradapters that incrementally fetch data, but my client wants to be able to scroll through a huge SQL table in a grid, so here I am.
>
>In my form's dataenvironment I add a cursoradapter, and using the builder I give it my connection handle, query, max number of records to fetch at a time, select fetch remote data as needed, and left it pretty much like that. No updates will be done - this is strictly a lookup table.
>
>I drop a grid on the form and it works well when just opening the form and scrolling through records - it appears to fetch incrementally nicely.
>
>Now I go to close the form.
>
>3 or 4 minutes later, it actually closes. My assumption is the cursoradapter is pulling the rest of the records for some reason before closing.
>
>Keep in mind - during development my SQL data is out in internetland, so I do expect slow responses, but since I'm not telling the form to retrieve any more data or to update anything, I would expect closing the form to be fast/instant.
>
>I've tried a couple of things in the form Unload event to close the cursor, tell the cursoradapter not to fetch data, etc but apparently I haven't hit the right combination to make it close in a reasonable amount of time.
Try with SQLCancel() in QueryUnload()
HTH
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement