cancel
Showing results for 
Search instead for 
Did you mean: 

is there any way to put the values inthe system matrix which is non editabl

Former Member
0 Kudos

is there any way to put the values inthe system matrix which is non editable...

this Q is not that much priority since i had achieved the requirement other way round by having user defined matrix ... but if i get the way for this it will help my add on performance much better...

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185703
Active Contributor
0 Kudos

Hi,

Just as a reminder:

This question has been asked and answered several times before in this forum. I propose that you might consider to first search the forum...

Regards,

Frank

PS: ...and please try to avoid duplicate posts ("... Define a User in ... 6.5 ...")

FOA
Advisor
Advisor
0 Kudos

Hi Raj,

You can always set values in visible columns in a system matrix, even when they are not active (editable as you said).

What is not possible using code is to set false or true the "visible" and "active" properties of an item in a system form.

Regards,

Felipe

Former Member
0 Kudos

hi Felipe,

thanx for ur reply....

but my problem is its not working in the form no 96.. item 11.. i am trying to add few more rows to this matrix..

i have attached my code here... could u please suggest me what to do ...

i had added the new row... and i have tried to change the value in the last row.. as the code below

oMatrix.Columns.Item("Document").Cells.Item(rownumber).Specific.Value = "A02520"

but i cant able to do this...

so what i did is... i had created a userdatasource and bind it to the new user matrix and i made the system matrix visible false... i know that i am doing the wrong way... please help me out in this...

FOA
Advisor
Advisor
0 Kudos

Hi Raj, I didnt get all the details but here some ideas how you can solve your issue:

Depending in the system form you are working you can always use a DBDataSource in order to manipulate the rows in a matrix. It's much better as using the objects of the matrix itself. In this case you can use:

oMatrix.FlushToDataSource()

oDBDsource.SetValue("U_Quan", pVal.Row, "101")

oMatrix.Clear()

oMatrix.LoadFromDataSource()

As you can see in SetValue i'm obtaining the Column, then the row number and then setting a NEW value for this cell.

Please consider if you can use DBDataSource instead of UserDataSource.

If the answer is yes then you can use the following:

oMatrix.FlushToDataSource()

'//Get the line you want

matrix.GetLineData(pval.row)

'//Call the Userdatasource assigned to that column

UserDataSource = UserDataSources.Item("ItmCode")

'//Set the new value

m_UserDS.ValueEx = "A02520"

oMatrix.LoadFromDataSource()

You can also use:

oMatrix.Columns.Item("ItemName").Cells.Item(l_rownum).Specific.String = "A02520"

In case you are not assigning the string in a combobox of course.

Good luck!

Felipe