Hi,
How do I create a empty matrix?
My matrix is a XML file.
I have a matrix which I key row by row with 3 colomn.
1 column is combobox
I assume I have to create the first row...blank...that's it... 😊
I have build matrix with data; here is the code:
oForm.DataSources.DataTables.Add("DATA_Matrix_A");
oForm.DataSources.DataTables.Item("DATA_Matrix_A").ExecuteQuery("SELECT [U_PayType],[U_Reference],[U_Amount] FROM [dbo].[@My_LOG] WHERE [Code] = '???'"); // I want blank Matrix
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).Columns.Item("mtxV_0").DataBind.Bind("DATA_Matrix_A", "U_PayType");
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).Columns.Item("mtxV_1").DataBind.Bind("DATA_Matrix_A", "U_Reference");
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).Columns.Item("mtxV_2").DataBind.Bind("DATA_Matrix_A", "U_Amount");
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).Clear();
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).LoadFromDataSource();
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).AutoResizeColumns();
//((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).AddRow(1, -1);
...but not a empty matrix without no data bounding....
...I will read the matrix line by line after and do a calculation of the data and log the input; so I can databound the matrix to my log file...
Thank you,
Rune