Guys,
I need to populate an attribute that is plain text 8.
The first four characters come from a plain text 4 attribute already existing in the database. No problem.
The second part (4 characters) comes from a number attribute that is initialised to zero. Each time I need to populate the plain text 8 attribute, I add one to the number field.
For example, the first time the plain text attribute will be populated with ABCD0001, the second time ABCD0002 etc.
The problem is that I can't get the four numbers to store with leading zeros - it currently looks like ABCD1.0 - and I don't know why.
On the number attribute, I defined a custom format ####, hoping that would do it. The format saves okay, but when I inspect the attribute, AwareIM has changed it to a decimal - hence the 1.0.
I also tried various things using AS_STRING, but that approach saves it as ABCD1 - no leading zeros before the 1.
Does anyone know of a trick to get the format with leading zeros working?
