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

The problem is the subselect returns the same result 90% percent of the
time which makes the select statement return the same result over and
over again.

If I run this statement seperatly it returns the correct result everytime.

The only solution I found is to select the

"select darno from CONVERTTORONUMBER where ronno = :DARNO_RONO"

into a seperate variable and using the variable for the where statement.

I doubt if the problem is my coding if it ease its probably an obscure
kind of logic error. If it is an error and if the error is fixed in
FB1.5 then please let me know.

I can provide the complete ddl for the sp if that would help.

Groete
Gerhardus