How to insert value to UDO tables using DI-API ?

[former_member189387]

Hi friends,

I have created Document and DocumentLine Tables ,using this i have created UDO .

I want to insert values to these tables using DI-API ?

Thanks

V.Rangarajan

[Former Member]

Did you get any help you share??

How did you do it??

[Gianluigi]

Nikhil / Quentin -

sorry but your code will not add a new object, will just add a new row in the

user table where the object resides. This is a huge difference. There is more

in the user object than just user tables and your code will not do all it needs

to be done in order to add a new object.

As Frank said, this feature is not yet available on B1 SDK

Sorry

[former_member209699]

Hi SAP Team,

I am also having same requirement.

Can anyone help me out?

regards:

SANDY

[Former Member]

Hi ranga,

you should try this code for insert values in your tables.

SAPbobsCOM.UserTable UDT;

UDT = oCompany.UserTables.Item("table");

UDT.Code = value;

UDT.Name = value;

UDT.UserFields.Fields.Item("field 1").Value = value;

UDT.UserFields.Fields.Item("field 1").Value = value;

UDT.UserFields.Fields.Item("field 1").Value = value;

int iErr = UDT.Add();

Hope it works.

[Former Member]

Hi Ranga

If it is user defined tables, I think you can use SQL with RecordSet object.

Somethings like :

oRecordSet.DoQuery("select * from [MyDatabase].dbo.[@MyUserTable] WHERE Condition");

Hope it helps

Quentin

[former_member189387]

Hi Quentin ,

Thanks for ur reply .

I want to use DI API Objects.

I wants to use Document Numbering Which B1 Generates.

Thanks

V.Rangarajan

[former_member185703]

Hi V.Rangarajan,

There is no object yet that would provide the functionality you are asking for.

You would have to use a workaround (enganging the B1 application) to do so at this point in time.

I still hope though that this gap will be filled "soon".

Sorry for the bad news.

Regards,

Frank

[Former Member]

Hi Frank,

you said: ' I still hope though that this gap will be filled "soon" '...

What is the definition of 'soon' ?

Regards,

Allan