Skip to Content
0
Former Member
Dec 10, 2011 at 07:10 AM

Please Help. INSERT INTO Table

46 Views

I want to ask what is the query for INSERT INTO in SDK?

I create a new table called OPSR in SBO-COMMON and I want to get the value of combobox and save it in my database. I'm having a error with INSERT INTO. Please check my code.

Dim oCompany As SAPbobsCOM.Company = SBO_Application.Company.GetDICompany
 Dim rsResult As SAPbobsCOM.Recordset = oCompany.GetBusinessObject

(SAPbobsCOM.BoObjectTypes.BoRecordset)

rsResult.DoQuery("INSERT INTO [SBO-COMMON]..OPSR (oFrom) VALUES ('" & oForm.Items.Item("Sample").Specific & "')")

I'm having a error in concatinating. And please check my code. Is that correct? Error with "&" Operator '&' is not define to string.

And I would also ask how to link to another form.

Please help. Thanks

Edited by: hikaru1207 on Dec 10, 2011 12:31 PM