>>lcSql = "select distinct student.cid from " +; >> "iepoint!student left outer join iepoint!facts on student.cid = facts.cStudentid " +; >> "left outer join iepoint!IEP3744_CONF on student.cid = IEP3744_CONF.cStudentid " +; >> "left outer join iepoint!enrollment on student.cid = enrollment.cStudentid " +; >> "where " + lmAllStuRules + " into cursor crsStudentsWhoMatchRules NOFILTER " >>&lcSql >>>>Still results are displayed in a browse window, and not set to a cursor.
>lcSql = "select distinct student.cid from " +; > "iepoint!student left outer join iepoint!facts on student.cid = facts.cStudentid " +; > "left outer join iepoint!IEP3744_CONF on student.cid = IEP3744_CONF.cStudentid " +; > "left outer join iepoint!enrollment on student.cid = enrollment.cStudentid " +; > "where " + lmAllStuRules + " into cursor crsStudentsWhoMatchRules NOFILTER " >EVAL(lcSql) >>EVAL() won't work here. EVAL() only works when you pass it an expression to evaluate. It can't do commands.