Checkbox in a Column

[Former Member]

Hello,

I have a Matrix-Column as a checkbox. Now i want do check/uncheck all Checkboxes in the Matrix with one button-click

   
oform.Freeze (True)
For i = 1 To 64
  oColumn.Cells(i).Specific.Checked = True
Next
oform.Update
oform.Freeze (False)

It works and all Checkboxes will be checked. But if i scroll down in my matrix the arrow in the box will be removed, but the checkbox is still checked. It seems that it is a Refresh-Problem?

Any ideas to solve this?

Thanks

Chris

[Former Member]

Hi,

I think that you have to change the field values with the DI, the UI just "shows" the values.

If I am wrong, please somenone correct me!

I had a problem, with the oForm.DataSources.DBDataSources.Item("@MyTable").SetValue(x,x,x)

, it doesn't work, doesn't apply the changes in the database.

I solved it using

oCompany.UserTables.Item("MyTable").UserFields.Fields.Item("FieldName").Value = "new value"

Ribeiro Santos

[Former Member]

Hi Ribeiro,

i have no datasource for this column

<column description="" disp_desc="0" editable="1" right_just="0" title="" type="121" uid="Col2" val_off="N" val_on="Y" visible="1" width="30"><databind alias="" databound="0" table=""/></column>

Could this be the problem?

[Former Member]

The userdatasource solved the "problem"

[Former Member]

See the DI example "06.MatrixAndDataSources", in "C:\Programas\SAP Manage\SAP Business One SDK\Samples\COM UI\VB.NET\06.MatrixAndDataSources\2003\"

maybe it help you.

Ribeiro Santos