V4MD void cursor if I add ORDER BY clause

[Ruslan Zasukhin]

On 12/4/05 12:56 PM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

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

And you need read carefully ValentinaSQL.pdf

It is said:

    you can ORDER BY only on field, which is SELECTed


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]