Updating matrix through edittext.string very slow.

[Former Member]

Hi,

i used the edittext update method to update the system matrix columns like Qty, Unit Price and few other UDFs. The program take 5 to 6 sec to update all the matrix columns. Is there a better option ? such as dbdatasource ?

''sample script below

Dim form As Form = B1Connections.theAppl.Forms.Item(pval.FormUID)

Dim item As Item = form.Items.Item("38")

Dim matrix As Matrix = CType(item.Specific, Matrix)

form.freeze(true)

Dim oNextEditText As EditText = matrix.Columns.Item(sColID).Cells.Item(pval.Row).Specific

onextedittext.string = "something"

form.Freeze(False)

form.Update()

[Former Member]

Yes, it is slow.

No, there is no alternative solution on system forms.

Sorry.

We have experimented, too, but you cannot do much.

[Former Member]

Hi Janos,

Does this mean i can use the GetLinedata and setlinedata as suggested ?

By the way, how exactly the Getlinedata and setlinedata used, can someone enlighten ?

KC

[Former Member]

Hi,

Instead of assigning the value directly to the column first get the matrix line data

then update the datasource then set the data to matrix line.

oMatrix.GetLineData(i)

// Update DataSource

oMatrix.SetLineData(i)

Hope it helps you

Regards

Vishnu

[Former Member]

Hi,

I am using system form.- Delivery Note..

Can you show the script in more detail ?