Hi!

Only another connection will help here. You cannot reuse existing connection till all records are downloaded. You can, however, force downloading of all records by making appropriate settings for connection (so all records will be loaded at once, that is the queckest approach), or call RecCount() function in case records are fetched to force fetch of all the rest records.

Well, for read-only data, the connection used to download data could be closed immediately after download. When no need to update data, you do not need that connection any more afterd ata downloading. This will take a few tenth or hundreds of milliseconds to re-connect each time to download read-only data.

HTH.

>Good morning everybody,
>
>I have a form that shows a grid which is binded to a cursor created with a SQLEXEC() command on a SQL server. I have set the Asynchronous property of the connection to .T. and the FetchAsNeed of the cursor to .T. because I don't want to wait after SQLEXEC() to finish to show my form... This works well, as I navigate through my grid, the missing records are fetched...
>
>I have, on this same form a button that shows another form with a grid (created the same way as the first form). The request executed by the second form has a WHERE clause in function of a field of my first cursor. So as I move in the first grid, I refresh the cursor for the second grid to show some information in relation about the first grid's current record... This works well too except a little something : If the records of the first cursor are not all fetched when I click on the button to show the second form, there's a delay because, if I understand well, the first SQLEXEC() has to finish before the second can be executed...
>
>I have the idea to make a different connection on each form, but I'm not sure it's the best way to do it...
>
>Any idea would be appreciate
>
>
>Regards