Copy all data from Matrix into Dataset
Trenikab
Hello all,
Is there a way to copy all data in a matrix into a dataset?
Anders Olsson
Hi,
There is no method on the matrix to get it directly, you will have to construct it yourself.
You can iterate over the rows and insert data to the dataset. If the matrix has a lot of data it will probably be quite a lot faster to get the data as xml and parse that. Example using Sales Order matrix (38):
SAPbouiCOM.Matrix matrix = (SAPbouiCOM.Matrix)SwissAddonFramework.B1Connector.GetB1Connector().Application.Forms.Item(pVal.Form.UniqueID).Items.Item("38").Specific;
string xml = matrix.SerializeAsXML(SAPbouiCOM.BoMatrixXmlSelect.mxs_All);
Regards,
Anders
0
Please sign in to leave a comment.
Comments
0 comments