select command

[Former Member]

hello expert

sir i want to select some feilds from database and display in perticular edit box during loading the form pls help me because i am new person for this

[edy_simon · Accepted solution]

Hi vmaskey,

For getting your data from database, you can use the oRecordset Object of the DI.

something like

Dim oRS as SAPBobsCom.oRecordset
oRS = ocompany.GetBusinessObject(boRecordset)
Dim sSQL as string = "SELECT yourfields FROM yourtable WHERE yourcriteria"
oRS.DoQuery(sSQL)

Dim sValue1 as string = oRS.Fields.Item("yourfields").Value

To Put it into the desired field during form load, please refer to your SDK Help Files.

Basically you need to catch the etFormLoad event at BeforeAction = False. and then assign your field as

oEdit = oForm.Items.Item("fieldID").Specific
oEdit.String = sValue1

Regards

Edy

[Former Member]

Hi

Which tool do you use for that?