Nick --

Have you tried putting the error info into an array, as follows:

aerror(laerror)

and viewing that in the debugger?

Jay

>I am running the following statement to create a SPT cursor. The first 2 cursors are created fine, it when I get to third cursor (ITCCursor) I keep getting -1 on my lnRes:
>
>
>

>UDFCursor = SYS(2015) && UDFields Cursor
>IF USED(UDFCursor)
>	TABLEREVERT(.t.,UDFCursor)
>ENDIF
>lnRes = SQLEXEC( thisform.nCon, lcSql, "UDFCursor" )
>IF lnRes > 0
>	q = RECCOUNT()
>	IF q > 0 && record available
>		SELECT UDFCursor
>......
>

>this one is ok
>
>

>lcSql = " Select *" ;
>+ "  FROM ITCRecordCount" ;
>RCTCursor = SYS(2015) && UDFields Cursor
>IF USED(RCTCursor)
>	TABLEREVERT(.t.,RCTCursor)
>ENDIF
>lnRes = SQLEXEC( thisform.nCon, lcSql, "RCTCursor" )
>IF lnRes > 0
>

>This one is okay also, but next one:
>
>

>lcSql = " Select * FROM ITCFields"
>ITCCursor = SYS(2015)
>IF USED(ITCCursor)
>	TABLEREVERT(.t.,ITCCursor)
>ENDIF
>lnRes = SQLEXEC( thisform.nCon, lcSql, "ITCCursor" )
>SELECT ITCCursor
>

>This one is not ok. I'm not doing anything different here than the other cursor creations. I seem to return -1 on lnRes. thisform.nCon is okay also. Is their a limitation to creating cursors? The table name (ITCFields) is correct on backend. Any Ideas?
>
>Thanks
>Nick Patel