I have a query that checks that when the user submits data to me, it checks that their total is correct.
The SQL looks like this:
Expand|Select|Wrap|Line Numbers
- UPDATE ETL_TBL SET ETL_TBL.ERR_CD = "805"
- WHERE (((ETL_TBL.OTHR_TOTL_AMT)<>([FOOD_TOTL_AMT]+[ADO_VSL_TOTL_AMT]+[MTG_ROOM_TOTL_AMT]+[GRNT_TOTL_AMT]+[OTHR_EXP_AMT]+[MGMT_FEE_TOTL_AMT])) AND ((ETL_TBL.OVRD_VALDN_IND)=No) AND ((ETL_TBL.VALD_STA_IND)=No));
Ever since that change, the code doesn't work, but it worked fine when they were Long Integer.
Thanks to anyone that can help