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