Hi all.

I want to make an instruccion in a trigger like that (don't works)

I want to update the field 'AMOUNT01' or 'AMOUNT02' .... etc as a function of date but raise an error

p.e.

SET MONTH='01';
EXECUTE IMMEDIATE 'UPDATE AMOUNTS SET AMOUNT'+MONTH+'=AMOUNT'+MONTH+'+100';

Any way to do that?

Thanks and Regards

Francisco,

<< I want to make an instruccion in a trigger like that (don't works)

I want to update the field 'AMOUNT01' or 'AMOUNT02' .... etc as a function
of date but raise an error

p.e.

SET MONTH='01';
EXECUTE IMMEDIATE 'UPDATE AMOUNTS SET AMOUNT'+MONTH+'=AMOUNT'+MONTH+'+100';
>>

Sure, that should work fine.   Please post the complete SQL that you're
using, along with the error message that you're seeing.  Also, please
indicate what version of ElevateDB you're using (Release/Build).

--
Tim Young
Elevate Software
www.elevatesoft.com