Hi Petros,
This can Happen when you have a shared connection, various views sharing the same connection with fetch as needed. you can do de following:
IF SQLGETPROP(nhandle, 'ConnectBusy')
SQLCANCEL(nhandle)
ENDIF
Now You can do the REQUERY(), note that this will cancel the fetchasneeded that you had on the other view.
>Hi all,
>
>I have a Remote view (ODBC Connection) calling an ACCESS table and I am doing a SCAN on it in order to delete some records (based on a condition) and I am getting the error message :
>
>" Connection MY_CONNECTION is busy "
>
>I tried to requery() the view or to put wait window before the DELETE command but I have the same problem.
>
>Please help me
>Thanks in advance
>Peter
Alexandre Palma
Senior Application Architect