>>I get the weird behaavior even when I do this:
>>

>>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.
>
>How about
>

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

Tamar