Hi,

I would like to use the DBDataSource object to get particular values from the database for example where the item code is xxx and fill a matrix with that information.

I am currently using:

dbDataSource = oForm.DataSources.DBDataSources.Add("OITM");

and then filling my matrix:

oColumn = oColumns.Item("code");

oColumn.DataBind.SetBound(true, "OITM", "ItemCode");

I would like to get an item with a particular item code.

oForm = globals.SBO_Application.Forms.Item(FormUID); oForm.DataSources.DataTables.Add("DATA"); oForm.DataSources.DataTables.Item("DATA").ExecuteQuery("SELECT CardCode, CardName FROM OCRD"); ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).Columns.Item("ColCC").DataBind.Bind("DATA", "CardCode"); ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).Columns.Item("ColCN").DataBind.Bind("DATA", "CardName"); ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).Clear(); ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).LoadFromDataSource(); ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).AutoResizeColumns();

i hope it helps

regards

David

You should use recordset or datatables and queries as

RecSet = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

RecSet.DoQuery("SELECT *FROM dbo.table WHERE...ORDER BY x")

for binding to matrix use datatables as

odbtable = oFormk.DataSources.DataTables.Add("x")

odbtable.ExecuteQuery(sql)

and bind column to datatbles as

column.DataBind.Bind("x", "cardcode")

Edited by: Petr Verner on May 26, 2008 9:41 AM

Hi,

in c# you define a recordset with:

SAPbobsCOM.Recordset oRecordSet = null;
oRecordSet = ((SAPbobsCOM.Recordset)(oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)));

i guess your code was vb petr

regards

David

Exporting Custom Analytical Query results to spreadsheet in S/4HANA Cloud in Enterprise Resource Planning Blogs by SAP Tuesday GRPO to Landed Cost to AP Invoice query SAP Business One in Enterprise Resource Planning Q&A Monday Sales Order to Production Order link query SAP Business One in Enterprise Resource Planning Q&A a week ago How to expose custom fields of Quality Notifications in SAP S4HANA Cloud public edition? in Enterprise Resource Planning Q&A 2 weeks ago Customer Business Partner Change Log History Query in Enterprise Resource Planning Q&A 2 weeks ago