[V4RB2] ORDER BY ?

Eric Ferrer wonderfef at noos.fr
Mon Apr 11 19:14:01 CDT 2005


Hello,

> v2 do not allow to have ORDER BY on field which is not in SELECT
> Actually this is SQL92 standard.

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

Safer or standard, maybe...
But the returned cursor will be bigger, generating more network trafic,
since you'll get fields that you won't use.
For some queries, this will not be an issue, for others, that may slow down
performances, don't you think?

Eric




More information about the Valentina mailing list