At 15:12 10.01.2003 +0200, you wrote:

>Hi
>I am still using FB1 where the problem is.
>
>This line of code is in a for select statement
>
>select VEHICLE_REGISTRATION_NO from DAR
> where darno = (select darno from CONVERTTORONUMBER where ronno
>= :DARNO_RONO) into :VehicleRegistration

Why not simply do

select VEHICLE_REGISTRATION_NO from DAR D
join CONVERTTORONUMBER C on C.DARNO=D.DARNO
where C.RONNO = :DARNO_RONO
into :VehicleRegistration

HTH

Set

- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation