Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INTO cursor Results to Screen
Message
From
12/12/2008 16:58:55
 
 
To
12/12/2008 16:50:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01367070
Message ID:
01367112
Views:
10
>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.

Are you sure there's no line break in lmAllStuRules? That would end the query after the WHERE clause and before the INTO.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform