Hi
I have the following trigger


ALTER TRIGGER PONT_LUNA_BA ACTIVE
BEFORE INSERT OR UPDATE OR DELETE POSITION 5
AS
  declare variable ii smallint;
  declare variable cZiC char(8);
  declare variable cVal char(5);
  declare variable cPon char(3);
  declare variable cSup char(1);
  declare variable cRec char(1);
BEGIN
        ii=1;
        while (ii<=31) do
        begin
            cZiC='new.z_'||iif(ii<10,'0'||cast(ii as char(1)),cast(ii as char(2)));
           execute statement cZiC into :cVal;
            cPon=substring(cVal from 1 for 3);
            cSup=substring(cVal from 4 for 1);
            cRec=substring(cVal from 5 for 1);
            ...
            ii=ii+1;
       end
END^
SET TERM ; ^

how do you assign variable values ​​cVal?
execute statement cZiC into :cVal;   does not work

thx!

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