Database lookup key field value is not stored in xmlwrapper

SYMPTOMS

When using Database lookup key the lookup key value does not get written to the field. The other values do get written.

CAUSE

Limitation of design

RESOLUTION

• Workaround is to add another extra field called (for example) DocID which is looked up and is actually the same field used for looking up. A dummy field so to speak.
• For example you would then have fields pk_1, t1,t2.
• Values for pk_1 will not get written to the field. Create an additional field called DocID. Use the value for pk_1 as the lookup field for DocID.
• DocID would be filled in with the value of pk_1 during the lookup. The same as the look up of t1 and t2 would be filed in with their coresponding values.

APPLIES TO

5.0 Service Pack 7; 6.0 Service Pack 1; 6.0 Service Pack 2; 6.0; 6.1; 6.1 Service Pack 1; 6.1 Service Pack 2; 6.2; 6.2 Service Pack 1; 6.2 Service Pack 2