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

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post