[V4RB2] ORDER BY ?

[Robert Brenstein]

>Hello,
>
>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?
>
>Regards,
>
>--
>Thierry Nauze               Saint-Denis de la Réunion


Actually, you should have done the same in v4rb1 
as well. In my experience with V1, some querries 
work fine without order by items in select, but 
others do not. It's hit and miss scenerio, so is 
safer to include them.

Robert