RE: SQLEXEC WITH A LOCAL CURSOR

> I Hope this is an easy question, I am using SQLEXEC to run a query on a MSSQL database. I am using a sub query of a cursor I create in the step before this query. Does SQLEXEC support this type of select statement?
>
> ~Dan

LOCAL lo AS OBJECT
SELECT localcursor
SCAN 
 SCATTER NAME lo
 TEXT TO lcSQL NOSHOW 
SELECT * FROM Ss_table 
 WHERE custno = ?lo.custid
 ENDTEXT 
 SQLEXEC(lnHandle, lcSQL , 'crs1')
 INSERT INTO sometable SELECT * FROM crs1
ENDSCAN 

-Anders