[V4RB2] ORDER BY ?

[Ruslan Zasukhin]

On 4/11/05 1:55 PM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

Hi Thierry, 
 
> I am adapting my program for V4RB2.
> 
> With V4RB1,
> curseur=db.SQLselect("SELECT id FROM individus WHERE id>0 ORDER BY
> nom,prenoms")
> returns the good cursor.
> With V4RB2, it returnsa nil cursor.
> 
> To obtain the good cursor, it is necessary to write:
> curseur=db.SQLselect("SELECT id,nom,prenoms FROM individus WHERE id>0
> ORDER BY nom,prenoms")
> 
> Is it deliberate or is it a bug?

v2 do not allow to have ORDER BY on field which is not in SELECT

Actually this is SQL92 standard.


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