Skip to Content
author's profile photo
Former Member

Screen painter, matrix and DataBound problem...

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Aug 17, 2004 at 09:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Aug 17, 2004 at 09:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded