Matrix Empty ComboBox XML

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Can you be more clear about what you want.

[Former Member · Accepted solution]

Hi Anuj,

Thank you very much for your feedback...

I like to build a empty matrix not bound to a table.

And I like to build 1 row in the matrix as the user move down in the matrix.

Plus the column 1 has a drop down list.

I like to have the answer in C# code, secondly in VB

Above you see the code I use to fill the matrix with data.

Please do not hesitate to contact me if you need more info...

Thank you,

Rune

[Former Member · Accepted solution]

To open the fields in the Matrix I have to change following parameters in my XML file:

<DataBrowser/>
                <Settings Enabled="0" MatrixUID="mtx_F_AA" EnableRowFormat="1"/>

Enabled="0"

has to be 0

I also has to change

editable="1"

per colum for the column I like to input data

[Former Member · Accepted solution]

How do I input a value to my row and column in Matrix?

I want to do something like this:

((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_F_AA").Specific)).Columns.Item("mtxV_2").HELP = ((SAPbouiCOM.EditText)(oForm_FCSDK.Items.Item("txtTotal").Specific)).Value;