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