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