General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only