Screen painter, matrix and DataBound problem...

[Former Member]

Hi

Using SAP BO 6.7 I have made a form with a matrix.

I have a usertable named @t_fingrp with a field named U_Nr.

In the matrix-->Columns properties I set Databound to "true", set tablename to "@t_fingrp" and set the alias to "U_Nr".

I then save the form as xml.

Then I load it in code using something like this:

********

XmlDocument XMLDoc1 = new XmlDocument();

XMLDoc1.Load(sXMLFile);

xml = XMLDoc1.InnerXml;

SBO_Application.LoadBatchActions(ref xmlString);

*****************

This will make the form appear in SAP BO with the matrix and the columns but NO data.

What am I doing wrong??

TIA

Jan

[Former Member]

Hi John

Thanks for the answer!

I hoped the data was shown manually when you bound the data in the Screen Painter GUI.

But apparently you only "saves" the binding code and still have to fill the matrix manually.

thanks for the help

Jan

[Former Member]

The data doesn't appear automatically when you bind a matrix to a data source. You have to populate the data source from the database, and then add each row to the matrix manually.

Below is a sample, hope it helps.

'Populate the datasource

Set sboDS = sboForm.DataSources.DBDataSources("OUSR")

sboDS.Query

'Add data to the matrix

For lngCount = 0 To sboDS.Size - 1

sboDS.Offset = lngCount

sboMatrix.AddRow

Next lngCount

John.