Hi Gerhardus,

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

In the debugger, I guess?

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

Rather send a backup of your db to me directly - that way I can test with
your
data.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."