[SQL] must return a sorted column?

[Ruslan Zasukhin]

on 3/2/04 8:04 PM, Tim Davis at timdavis at amug.org wrote:

> Hi,
> 
>   I've noticed many times that Valentina Server will crash if in an
> SQL query a column which is used in ORDER BY in not a SELECTed column.
> In other words, you must return a column you are using in your sort. Is
> it normal for an SQL to freak out at such a query? Or please let me
> know if this has been very recently resolved (as I have already coded
> around this).

Hi Tim,

1) Crash must not happens of course

2) by standard sorted column MUST BE in select.
    
Some DBMS allow skip this rule.

First versions of Valentina also did this.
Later this was changed. Not remember reason.

So YES, you must now SELECT column that is used in ORDER BY.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------