Thursday, June 17, 2010

COM error when exporting data...

I've been getting the following error when trying to export some data to Excel using Definition groups:

Method 'item' in COM object of class 'Range' returned error code 0x800A03EC () which means: .

At first I noticed it was only happening when adding the field RecId to the "Field setup" of the export. The problem isn't really the field itself, but actually the way it was being added. When adding a table to a definition group, it automatically pulls in all the fields of that table (except some system fields like TableId, RecId, DataAreaId, etc.). So when you hit the Setup button, it already contains most of the fields.

The table used to store that selection is SysExpImpField. There's a record for each field and it saves the selected field ids in ConvFieldId. It is important to note that it's actually the extended field id that is saved (Field id + array index). From the setup form we have 2 ways of adding more fields, either by using the lookup or by manually typing the name of the field.

If we use the lookup, it calls the Global::pickField function and returns the extended field id selected. However, if we type the name of the field, it will then use the function fieldname2id. fieldname2id returns the FieldId NOT THE EXTFIELDID...

So I added a quick hack to the edit method SysExpImpField.fieldName :


// BP Deviation Documented
edit fieldName fieldName(boolean set, fieldName name)
{
if (set)
{
this.ConvFieldId = fieldname2id(this.ConvTableId, name);
//MVaillancourt. Haka. 20100617
//fieldname2id does not return the extended fieldid. if the id is smaller than 65 536, convert to extended
if (this.convFieldId < 0x10000)
this.convFieldId = fieldid2ext(this.convFieldId, 1);
//MVaillancourt. End
}

return fieldid2name(this.ConvTableId, this.ConvFieldId);
}

1 comment:

gnagna said...

Hey there, this is great! had the same issue, your post help me fix quickly. Thanks!