set values in matrix

[Former Member]

hi ,

i created matrix in screen painter. it includes 3 columns unit of measurement, length, width.

i want to set values to length and width manually.

when the form is loaded the length and width should appear in matrix

Regards,

Puneeth

[Former Member · Accepted solution]

Here an sample to add DataSource-Information via a XML-Editor.

    <form appformnumber="WREDE_CREDITNOTES" FormType="WREDE...
              <datasources>
                    <dbdatasources>
                        <action type="add">
                            <datasource tablename="@WREDE_CREDITNOTES"/>
                            <datasource tablename="@WREDE_CN_LINES"/>
                        </action>
                    </dbdatasources>
                    <userdatasources>
                        <action type="add">
                            <datasource uid="FolderDS" type="9" size="1"/>
                            <datasource uid="NumAtCard" type="9" size="100"/>
                            <datasource uid="cnnumber" type="9" size="100"/>
                            <datasource uid="dnline" type="0" size="4"/>
                            <datasource uid="lines" type="0" size="4"/>
                            <datasource uid="sum" type="6" size="8"/>
                            <datasource uid="sum2" type="6" size="8"/>
                            <datasource uid="draft" type="0" size="4"/>
                            <datasource uid="Folder2" type="9" size="1"/>
                            <datasource uid="FolderDS" type="9" size="10"/>
                            <datasource uid="FolderDS" type="9" size="10"/>
                        </action>
                    </userdatasources>
                    <DataTables>
                        <DataTable Uid="OPENDN">
                            <Columns/>
                        </DataTable>
                    </DataTables>
                </datasources>
                <Menus>

[Former Member]

Hello Pooneth,

In a short way I can answer:

1) You should use UserDataSource for each column (look for samples in the SDK). You have to bind the UserDataSource to the Column = Alias is the ID of the UserDataSource, Bind = true, Table leave blank.

1a) When you like to store the data in a direct way to a database-table you can also have a look to the DBDataSource.

2) Defining the UserDataSource is not included in the Screenpainter. You can add the Definition with an XML-Editor for example. Or via SourceCode. The definition contains information of the datatype, for example you need to define it as dt_MEASURE or dt_QUANTITY (BoDataType Enumeration in the SDK-Help Center) .

3) Then you need an event-handler. Listen to the VALIDATE-event for example.

I think, this was your missing Information, that you have to bind your columns to an DataSource to be able to write data into this columns.

Kind regards

Christian

PS:

4) To set Values there are two different ways:

- UserDataSource -> like this:

UserDataSource.ValueEx = "0.01";

Matrix.SetLineData(row);

or: MAtrix.AddRow(1, -1);

- DBDataSource -> like this:

DBDataSource.SetValue("U_MYLENGTH", index, "0.01");

Matrix.LoadFromDataSource();

I hope, you know what I meen with this samples.

Edited by: Christian Bührig on Jun 24, 2008 8:53 AM