Try to use number instead of field name, e.g.

Value= 1,2 ; 2,1

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Joel do Prado Junior" <JoelIbObjects@...>
To: <ibObjects@yahoogroups.com>
Sent: Thursday, March 08, 2001 12:33 PM
Subject: [IBO] Problem Ordering !


> Query.SQL -> select Debit as Value,Data from Table
> union
> select Credit as Value,Data from Table
>
> Query.Ordering -> Value,Data=Value,Data;Value Asc;
>
>
> Query.OrderingItens-> Value=1;
>
>
> Message error-> Invalid order by clause.
>
> clause union no ordering ?
>
> thanks.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>