IF thisform.opgSortDirection.option1.Value = 1 &&Ascending SELECT * ; FROM curBrowseModal ; ORDER BY cSortSeqASC ASC ; INTO CURSOR curBrowseModal ELSE SELECT * ; FROM curBrowseModal ; ORDER BY cSortSeqDSC DESC ; INTO CURSOR curBrowseModal ENDIFIf I try to solve the problem by setting the recordsource to curBrowseModalS and executing the following, I get an empty grid!
IF thisform.opgSortDirection.option1.Value = 1 &&Ascending SELECT * ; FROM curBrowseModal ; ORDER BY cSortSeqASC ASC ; INTO CURSOR curBrowseModalS ELSE SELECT * ; FROM curBrowseModal ; ORDER BY cSortSeqDSC DESC ; INTO CURSOR curBrowseModalS ENDIFAnd if I create the curBrowseModalS ahead of time, I get a zero columncount!