> -----Original Message-----
> My sp throws "multiple rows in singleton select" whenever
> more than one order is returned

Shouldn't the following statement be a for select?

begin
select S.TrackId,S.ConId, S.Upliftment, S.InvNo, S.InvValue,
S.LoadCartons, S.DelDate, S.DelCartons, S.DelCode
from TrpTrn S
where S.DepotId=:DepotId and S.PrnId=:PrnId and S.TrackId=:bTrack
into :TrackId,:ConId, :Upliftment, :InvNo, :InvValue, :LoadCartons,
:DelDate, :DelCartons, :DelCode;
suspend;
end


Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfBB - Web based, Firebird Powered Forum