Its Important-UI Databse Interface

[Former Member]

Hello,

I am new to UI, I need a sample or an Idea for Interface a GUI Text Box Value from SBO XML form to SBO Database.

This action should perform only when i press an OK button.

pls send a simple code or the procedure/concept.

Thankx & Regards

Thiru

[Former Member · Accepted solution]

Hi Soundrarajan,

You cannot just write to the database, "if I understand you correctly"

You need to use user-defined fields to update the data.

For example, if I add a userdefined field to the Documents option , call U_Myfield. I would then browse to the record using the YourObject.UserFields.Field(1) to set my object and then update.

I give you some sample code that writes into the OINV database as a user-defined field.

Note you need to open both a UI connection and a DI connection - See the UI/DI documentation or browse on the SDN, there is some information

                Dim OITMOBject As SAPbobsCOM.Items
                OITMOBject = vcmp.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oItems)
            OITMOBject.ItemCode = Trim(Scanindb.GetValue(0, i))
                            OITMOBject.Manufacturer = "-1"
                            OITMOBject.ItemsGroupCode = "101"
                            OITMOBject.UserFields.Fields.Item(4).Value = "MyVal1"
                            OITMOBject.UserFields.Fields.Item(5).Value = "Myval2"
                

If you have more help, feel free to ask, but tell me in what table you need to write and why.