Joel,
you cannot order by an alias, i.e. ORDER BY VALUE is illegal. You must
order by the real name of the column or its ordinal position. Since you use
UNION you cannot use the name and have to use the ordinal position, i.e.
ORDER BY 1.

Change to something like

>Query.Ordering -> 1,Data=1,Data;1 Asc;

or

>Query.Ordering -> 1,2=1,2;1 Asc;

(I don't know whether you can mix names and ordinal position or not)

HTH,
Set

At 08:33 08.03.2001 -0300, you wrote:

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