General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only