Subject Re: [firebird-support] ORDER BY invalid column
Author Alexandre Benson Smith
Rick Debay wrote:

>I was running a one-off query in order to do some inventory analysis,
>and got this error. FB will only allow me to choose columns returned
>from the table in this query, not generated columns (ORDER BY 9 also
>fails). Which is strange, as I know I've used generated columns in
>other queries.
>Dynamic SQL Error SQL error code = -104 Invalid column position used in
>the ORDER BY clause
> p.*,
> (p.decimalqty - p.order_qty - p.po_qty - p.bo_qty) outstanding,
> (select first 1 d.labelname from mddb_drug d where d.PRODUCTID/100 =
>p.ndc9) <== column 10
> P_RPL_NDC9_2( '01J' ) p
> (p.decimalqty - p.order_qty - p.po_qty - p.bo_qty) > 0
>order by
> 10

Name each column from Procedure P_RPL_NDC9_2 (P) instead of using p.*

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil