[V4RB] order by ullong field

[Ruslan Zasukhin]

On 6/15/05 5:31 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

> 
> Le 15 juin 2005 à 16:09, Ruslan Zasukhin a écrit :
> 
>> It have such name  ULLONG  ?
>> This will not work because ULLONG  is keyword of SQL
> 
> Of course, my field name is NOT ULLONG.
> 
> SELECT Name FROM Clients ORDER BY CreationDate
> 
> Name is a varchar
> CreationDate is ullong
> 
> 
> VServer says that CreationDate does not exist, and I swear it does.

Aha,

In 2.0 we follow standard of SQL92

    you can ORDER BY only fields that in in SELECT

So you need

   SELECT Name, CreationDate FROM Clients ORDER BY CreationDate


-- 
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]