>lnSql = SQLCONNECT('SomeDataSource')
>
>* Check for lnSql > 0, if successful
>
>USE MyDB!View1 IN 0 CONNSTRING lnSql
>
>USE MyDB!View2 IN 0 CONNSTRING lnSql
>&& Error 'Connection MyDB is busy'
>
>
>So I put in a
>
>DO WHILE SQLGETPROP(lnSql,"ConnectBusy")
>ENDDO
>
>But that just caused the thing to go into a forever loop.
>
>Funny thing is, it works in the debugger.
>
>What to do?

Hi Peter,

Most likely the error is reported because the View1 hasn't finished fetch by the time you are trying to open View2. To avoid the error, execute GO BOTTOM IN View1 before USING View2 or simply change View1's FetchSize property to (-1) in DBC.

Thanks,
Aleksey.