At a quick glance, I think you need to CTXT the value in the second
formula.
Albert
On 2015-12-16 4:08 PM, Bruce Chitiea wrote:
All:
RBGXE
Data Designer - defining computed column 'EMEContSubCatCODE'
Error Message: "Column or variable EMEContSubCatORDR not found (2515)"
Code:
( (CTXT(EMEContCatID)) + (IFF('EMEContSubCatORDR<10','-0','-')) +
(CTXT(EMEContSubCatORDR)) )
Table definition:
EMEContSubCatID INTEGER nn pk
EMEContCatID INTEGER nn fk
EMEContSubCatORDR INTEGER nn
EMEContSubCatCODE TEXT (6) COMPUTED nn
The table was saved successfully before the computation was entered,
saves successfully after the code is removed.
Thanks for your help.
