Hello Community,



i have a problem with my procedure:



AS/**/

declare variable cnt integer;

declare variable oldstatpos varchar(2);

declare variable oldstatus varchar(200);

BEGIN

oldstatus = '';

for select status from aa_auftrag_2 where PID = :PID into :oldstatpos do

oldstatus = oldstatus || oldstatpos;

.

END



Oldstatus = oldstatus || oldstatpos; sadly, as result the oldstatus-variable
has the value NULL. The variable was supposed to 'oldstatpos + oldstatpos'
and not null.



Please, can you help me what's the matter?



Thank you.


Olaf Kluge








[Non-text portions of this message have been removed]