Subject execute statement for local variables
Author Olaf Kluge
Hello,



I have the following:



declare variable pos1 integer;

declare variable pos2 integer;

declare variable pos3 integer;

declare variable pos4 integer;

declare variable pos5 integer;

declare variable pos6 integer;

declare variable pos7 integer;

declare variable pos8 integer;

declare variable tmppos integer;

declare variable stm varchar(100);

begin

for select rasterpos from tlepos where leid = :le and bestandsnr is null

order by rasterpos asc

into :tmppos do

begin

stm = 'pos' || :tmppos || '=1' ;

execute statement stm;

end



Rasterpos can be from 1 to 8 , for each rasterpos can be occupied or not.
(bestandsnr is null or an inventory number)

When the rasterpos is free, the local variable pos[andrasterpos] (pos1 to
pos8) should get the value 1.



stm = ':pos' || :tmppos || '=1' ; works not too (with : )



Thank you.







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