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 > 0This 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 ITCCursorThis 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?