Skip to Content
0
Former Member
Feb 12, 2009 at 08:14 PM

Matrix Empty ComboBox XML

15 Views

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