V4MD void cursor if I add ORDER BY clause
Ruslan Zasukhin
sunshine at public.kherson.ua
Sun Dec 4 13:01:10 CST 2005
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? :-)
> Thanks Paolo
This is why I recommend again to use link_count() function.
Read about it in Valentina SQL.pdf
This way is faster, and it do not have limits of GROUP BY way
--
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]
More information about the Valentina-beta
mailing list