[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