Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
About trigger |
Thu, May 6 2010 6:24 AM | Permanent Link |
Francisco Fernandez NewTRON Informatica | 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 |
Thu, May 6 2010 5:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |