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