SDK VB recordset

[Former Member]

Alguien puede ayudarme ... necesito saber como puedo poner un campo en el codigo sql como parametro

--------------------

Someone can help me ... I need to know how I can put a field in SQL as parameter

sql = "Select CardName from OCRD where CardCode='" & {param} & "'"

        oRecordSet = SBO_Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

        oRecordSet.DoQuery(sql)

[Former Member]

Hi,

     I think there's nothing wrong in your query. In VB I'm using like

oQry = "SELECT CardCode, CardName FROM OCRD WHERE CardCode = '" & txt_Code.Value & "' "

txt_Code is a EditTextBox.

oRecordSet = SBO_Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

        oRecordSet.DoQuery(oQry)

Regards,

Bry

Blog: http://www.sap-tips-tricks.com/

[Former Member]

A picture is worth a thousand words

[Former Member]

Oh, the problem is the oComboBox. Have you bind it already?

oComboBox = oForm.Items.Item("ComboBox").Specific

Regards,

Bry

Blog: http://www.sap-tips-tricks.com/