Problem in Matrix control

[Former Member]

Hi,

When i develope a add on form i used the matrix control to capture more data. <b>I can't edit the matrix contol in run mode.</b> How to add the new record thru Matrix. If not what is the alternate way. My requirement is to Enter the purchase Requestion. For that i need to capture the data in header level for some fields and Item details,Required quantity and Required date in Row level. For that i used Matrix. Is it correct?

[former_member184566]

Hi

You have to get a handle to your matrix.

oMatrix = SBO_Application.Forms.Item(FormUID).Items.Item(MatId).Specific

Then add a row.

oMatrix.addrow()

You will be able to type now in the cells.

But as soon as you exit the cell it will lose the contents.You must either add datasources or you must link this to tables that are part of a UDO to avoid retain the data in the cells.

Hope this helps

[Former Member]

Thanks Louis,

now i can ente the value in Matrix.

In my case i am using 2 tables, one for header and another one for Details. in this case how to bind the data source to matrix and header levele fields? Can you help on this?

If possible put some sample coding in your reply.

Thanks in Advance..

Suresh R

[former_member184566]

Hi

Look in your install directory, there are a few samples that one can use. Look in C:\Program Files\SAP\SAP Business One SDK\Samples\COM UI\VB.NET then at sample 06.MatrixAndDataSources

If you are building a form similar to SAP Business One documents like Sales Order have a look at UDO. The UDO will do all the work for you like inserting in the database, allocating a doc number, scrolling through the records.

Hope this helps