Hi Sean;

If I do that, I get:

select "TPRO"."DSCR" as "D_TPRO", "OTIP"."NUME" from "OTIP" left
outer join "TPRO" on "OTIP"."TPRO"="TPRO"."TPRO"
where "OTIP"."PROC"='1KZM64V704'
order by "NUME"
*** IBPP::SQLException ***
Context: Statement::Prepare( select "TPRO"."DSCR" as "D_TPRO",cast
(' ' as character(1)) as "NUME" from "PROC" left outer join "TPRO"
on "PROC"."TPRO"="TPRO"."TPRO" where "PROC"."PROC"='1KZM64V704'
union
select "TPRO"."DSCR" as "D_TPRO", "OTIP"."NUME" from "OTIP" left
outer join "TPRO" on "OTIP"."TPRO"="TPRO"."TPRO"
where "OTIP"."PROC"='1KZM64V704'
order by "NUME" )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Invalid command
invalid ORDER BY clause

Dany