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]
