STORE "ar" + Sys(2015) TO arCursors[iWords], lcArrayName .... Select cKeyVal ; From (lcQueryTable) ; Where Upper(cItmKey) Like ( cCurrWord ) Order By cKeyVal Top 500 ; Into Array &lcArrayName>Running this code gives me the error "SQL: Statement is Invalid". What did I do wrong?
>lcString = "universal thread" >lcQueryTable = "allwords" >For iWords = 1 to ( GetWordCount(lcString) ) > arCursors[iWords] = "ar" + Sys(2015) > cCurrWord = Alltrim(GetWordNum(lcString,iWords)) + "%" > ? "-----" + Alltrim(Str(iWords)) > ? cCurrWord > ? (arCursors[iWords]) > Select cKeyVal ; > From (lcQueryTable) ; > Where Upper(cItmKey) Like ( cCurrWord ) Order By cKeyVal Top 500 ; > Into Array ( arCursors[iWords] ) >Next >>