Skip to Content
0
Former Member
Dec 16, 2007 at 04:56 AM

Updating matrix through edittext.string very slow.

27 Views

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()