V4MD void cursor if I add ORDER BY clause

info at vallemediatime.com info at vallemediatime.com
Sun Dec 4 11:56:46 CST 2005


Hi, again

This query works:

query = "SELECT Reg_ID, Person_LastName || ' ' || Person_FirstName, 
Course_Name, \
Reg_Day || '-' || Reg_Month || '-' || Reg_Year \
FROM Registration, Person, Courses \
WHERE Reg_Code = 2  \
AND Person_ID = Reg_Person_Ref  \
AND Course_ID = Reg_Course_Ref  "


But if I want to add a ORDER clause I get a VOID cursor
eg
query = "SELECT Reg_ID, Person_LastName || ' ' || Person_FirstName, 
Course_Name, \
Reg_Day || '-' || Reg_Month || '-' || Reg_Year \
FROM Registration, Person, Courses\
WHERE Regi_Code = 2 AND Person_ID = Reg_Person_Ref AND Course_ID = 
Reg_Course_Ref  \
ORDER BY Reg_Year "

Another good suggestion?  :-)
Thanks Paolo 



More information about the Valentina-beta mailing list