Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Records missing from SQL query
Message
From
01/05/2004 09:44:43
Steven Kleypas
Tarrant County College District
Texas, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00899906
Message ID:
00900023
Views:
17
Good question Sergey. This cursor is going to be used as the controlsource for a variety of reports. One of the options presented to the user is to print a report for an individual student or all of the students in the course. To accomplish this, I want to add another expression to the WHERE clause...
.
.
WHERE courses.iid = iCourseId AND students.iid = iStudentId
.
.
If wildcards are an option, I have the flexibility of using the cursor for both situations; one dataenvironment, one cursor to maintain for more than a dozen reports.

Thanks!
Steve
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform