Skip to Content
0
Former Member
Mar 29, 2006 at 09:57 AM

How to select registers?

17 Views

I have one projecto with matrix seemed with the example demonstrated in C:\Program Files\SAP Manage\SAP Business One SDK\Samples\COM UI\VB.NET\06.MatrixAndDataSources\2003. I created a table, @PTSFCT, in SAP Business One.

I can bind to the table oDBDataSource = oForm.DataSources.DBDataSources.Add("@PTSFCT") and place all the values in matrix.

However, I would like to only select some data of the table using a Query.

For example: I would like to only show the registers of the table whose Num_Contrat is 1. How I must you make it?