>Hi all.
>
>I have a VFP 6 SP3 app running with a SQL 7 Backend. I m using shared connections but want I want to retrieve a small recordset -280 records- I get the -Connection is busy- error. I have set the rows to retrieve to 100. When I set it to 300 the problem is gone but I'd like to be able to download the data in the 100 records rate because I have a slow connection to the server. Any idea?
>
>
>TIA

You can check first if the connection is busy the execute the new command

nconnectionhandle=CURSORGETPROP('connecthandle')
DO WHILE SQLGETPROP(nconnectionhandle,"ConnectBusy")
Upload.progress.value = "Connection is busy..."
Upload.progress.refresh
ENDDO

Regards

Xavier