>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'

If your using VFP 8.0 try this:

lnSql = SQLCONNECT('SomeDataSource',.t.)

* Check for lnSql > 0, if successful

USE MyDB!View1 IN 0 CONNSTRING lnSql
USE MyDB!View2 IN 0 CONNSTRING lnSql

If that doesn't work, put this line after you first use:

CursorSetProp('AllowSymultaneousFetch',.t.)

BOb



>
>
>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?