Skip to Content
0
Former Member
Jan 21, 2008 at 08:51 AM

Faster way to add user table

34 Views

now i'm using code to add new table such as this:

-


oUserTablesMD = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oUserTables)

oUserTablesMD.TableName = oDataRow(ARR_DT_FIELDS(0))

oUserTablesMD.TableDescription = oDataRow(ARR_DT_FIELDS(0))

oUserTablesMD.TableType = oDataRow(ARR_DT_FIELDS(1))

lRetCode = oUserTablesMD.Add

-


but when i add fields, it takes very long time

-


oUserFieldsMD = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oUserFields)

oUserFieldsMD.TableName = oDataRow(ARR_DT_FIELDS(2))

oUserFieldsMD.Name = oDataRow(ARR_DT_FIELDS(0))

oUserFieldsMD.Description = oDataRow(ARR_DT_FIELDS(0))

oUserFieldsMD.Type = oDataRow(ARR_DT_FIELDS(1))

oUserFieldsMD.Add

-


is there any other way i can add a new table?? such as XML ? or add it manually at Exterprise Manager and then add info in the related table eg:CUFD . But i tried, it doesnt work .... i dunno is there any other table involved.....

the code is too slow.... i'm talking about 100+ tables and it seems to take forever to load ...