[V4MD] Query works in ViSQL, but not in Director

[Ruslan Zasukhin]

On 5/18/04 1:10 AM, "Keith Ulrich" <keith.ulrich at verizon.net> wrote:

Hi Keith,

> 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?

The first idea which come to mind:

-- do you use LATEST viSQL utility ?
    i.e. Based on Valentina 1.10 engine?

Then note that V4MD that you use is 1.9.6.
This is very old version.
May be it have had bug.
    
So in the first tune it will be great if you upgrade to 1.10



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------