do{ ttsbegin; row++; NumberSeq = NumberSeq::newGetNumFromCode(BOMParameters::numRefBOMId().numberSequence); bom.BOMId=NumberSeq.num(); bom.Name=cells.item(row,1).value().bStr(); bom.ItemGroupId=cells.item(row,2).value().bStr(); bom.SiteId=cells.item(row,3).value().bStr(); bom.insert();
type= cells.item(row+1,1).value().variantType(); ttscommit; }
I'm trying to import the value into ax BOMTable, all the values got inserted except the siteId...
I checked the relations to, shall I know how to insert it from excel?
Thanks.