Subject | execute statement for local variables |
---|---|
Author | Olaf Kluge |
Post date | 2011-05-28T10:34:28Z |
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]
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]