hanszorn2000 wrote: > declare LOCATION integer; > declare ARTICLEID varchar(20); > BEGIN > select first 1 NEWLOCATION, ARTICLEID from ARTICLE > where ARTICLE.CUSTID = NEW.CUSTID > and ARTICLE.ISACTIVE = 'F' > and ARTICLE.NEWLOCATION is not null > order by NEWLOCATION > into :LOCATION, :ARTICLEID; > > NEW.NEWLOCATION = LOCATION;
You have a potential bug here. What if select does not return a row? In that case variable LOCATION has uninitialized value, i.e. it could contain anything (perhaps a value from some previous run). Try adding... LOCATION = NULL; ...before the SELECT query. HTH -- Milan Babuskov ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==================================
