cancel
Showing results for 
Search instead for 
Did you mean: 

Update values in a matrix on a system form

former_member221339
Participant
0 Kudos

Hi

In B1 V9 I want to set some values in the matrix on the AR Invoice system form

Is there a way to do this with datasources to cut down on the screen flashing or can this only be done on user defined forms ?

I normally use something like -

matrix.Columns.Item("14").Cells.Item(1).Specific.string = 15

Thanks for any help

Regards Andy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Andrew,

Unfortunatly, with system forms you cannot access the datasource objects directly: you have to go thru the graphical objects only.

Writing this, you have two workarounds:

  • Freeze the form before starting to update it: by doing so you are going to avoid the flashing,
  • Use the Matrix.SetCellWIthoutValidation function, which will allow you to modify the data, avoid the flashing and avoid the Validate event.

My best bet would be to use both methods at the same time.

Regards,

Eric

former_member221339
Participant
0 Kudos

Hi Eric

I have tried the freeze option in earlier versions and I seem to remember it not working that well

The Matrix.SetCellWIthoutValidation function sounds good, will try that and update you

Thanks for your help

Regards Andy

former_member221339
Participant
0 Kudos

Thanks Eric

That works well

Regards Andy

Former Member
0 Kudos

Hi Andrew,

Glad to have helped.

Regards,

Eric

Answers (0)