[V4MD] Query works in ViSQL, but not in Director
Keith Ulrich
keith.ulrich at verizon.net
Mon May 17 18:10:17 CDT 2004
I'm using V4MD version 1.9.6.0 with Director MX on Windows 2000. I'm also
using ViSQL Win32 1.1a22.
This query works fine in ViSQL:
SELECT lastName, firstName, middleName, examScore, examDate, configDate,
release
FROM Units, UnitEnrollment, Configurations, ExamScores, Students
WHERE UnitEnrollment.unitID = Units.unitID AND
Configurations.unitID = Units.unitID AND
Configurations.configID = ExamScores.configID AND
ExamScores.studentID = Students.studentID AND
Students.studentID = UnitEnrollment.studentID AND
Units.unitID = '7919799'
ORDER BY configDate, examDate
But I can't get a cursor with the same query in Director. I tried to
isolate the trouble spot by making the query progressively more
complicated, and for some reason it always works until I add the
UnitEnrollment table. But like I said, ViSQL handles the query fine.
Any idea what I'm doing wrong?
Thanks.
Keith Ulrich
More information about the Valentina
mailing list