Yeap, but it isn't a Query, it is a Structured T-SQL procedure, for this you can create an temporal Stored Procedure, execute it & get the result cursor.



>Hi Esparta,

>Visual FoxPro execute local build of cursor!

>On Visual FoxPro
>Simple examples:

>BEGIN TRAN; SELECT .... -- ok

>IF ..... SELECT .... -- ok

>SET ... ; SELECT ... -- ok

>DECLARE @X INT; SET @X=1; select @X -- NONE CURSOR IS BUILD

>UPDATE/INSERT/DELETE ... ; SELECT @@IDENTITY -- NONE CURSOR IS BUILD

>-- BATCH MODE =.T.

>DECLARE @X INT; SELECT @@IDENTITY X; SET @X=1; SELECT @@IDENTITY Y
>-- 1 CURSOR AND 1 ERROR

>Fabio