Using Concat in ORDER BY

[Ruslan Zasukhin]

On 11/30/04 3:43 AM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:

> Hi,
> 
> I'm converting some SQL I have running in MySQL over to Valentina 1.x.
> I have a query which orders records returned using the Concat function.
>   Here is a simplified query which shows the basic concept:
> 
> SELECT Title, Sequence FROM lesson ORDER BY Concat(Sequence, '.', Title)
> 
> I keep getting 604 syntax errors though.  Is this type of ordering
> possible in Valentina 1.x and if so what is the proper syntax?

Hi Trevor,

You need create BaseObject mehod and use it in the 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
-------------------------------------------------------------