Updating a multiple value field from the view

HCL Domino Domino Forum
1

i have a view with 10 columns.all 10 columns are multiple-value fields.

in the column properties, for each column, i have selected “show multiple values as separate entries”, and i have also specified “new line” as the multi-value separator.

in the view properties, 3rd tab, “Rows” section, i have selected a height of 2, and i selected “shrink rows to content”

i want to be able to update all columns from the view.

so, i have checked off “editable column” in the column properties.

in the InViewEdit event for the view, i pasted in a chunk of code that i copied straight from the online help, from the examples of InViewEdit.

when i look at the view in the Notes Client, i can update a column, but when i do , i lose all of the other multiple values for that field.

in other words, if my field “num” has 3 values {1;2;3}, the view will display 3 lines, the values for the column “num” being 1, 2, 3.

i want to be able to update the value in row 3 from 3 to 4, so my field should have multiple values {1;2;4}.

but after i update that column in row 3, all 3 rows display the value “4” in that column, and when i look at the contents of the field it just shows {4}.

why can’t i update just one of the multiple values from the view?

2

Subject: updating a multiple value field from the view

Are you entering the values with the separator defined in the multi-value field?

For {1;2;3} you would enter {1;2;4}, if a semicolon is the separator…

I’m guessing you are probably not doing this, but thought I would throw this out there…

HTH,

Dan

3

Subject: RE: updating a multiple value field from the view

i am new to Notes, i have used Powerbuilder for years.so i’ll try to explain it better.

there is only one document.

it has 4 text fields, each of which allows multiple values.

currently each field has 3 different values.

i have made the view display each value as a separate row, so even though there’s only one document, the view is displaying 3 rows.

the columns on the view are editable.

so , if a field named “color” has the values RED;BLUE;GREEN,

it will display in the view as:

RED

BLUE

GREEN

i would like to be able to click on this column , 3rd row, and change GREEN to BLACK, while leaving the other 2 values (RED and BLUE) unaltered.

is this not possible with NOTES??

after i change GREEN to BLACK, the view displays

BLACK

BLACK

BLACK

!!

4

Subject: RE: updating a multiple value field from the view

As long as you are using Notes 6.5, you can capture the existing values in the QueryRequest (by getting the value from the document rather than the columnvalue) and throw them to a global variable (a Variant) before the edit. You’ll also want to capture the columnvalue in the QueryRequest so you know which of the values to replace in the SaveRequest. Then it’s a matter of doing an ArrayReplace on the Variant with the new columnvalue and the old columnvalue.

5

Subject: RE: updating a multiple value field from the view

thanks for your response,by QueryRequest, i assume you mean the QueryRequest section in the Inviewedit event.

i am struggling to write the code to capture the values from the document. i assume you have to use the Colprogname argument somehow.

can you offer an example of what the code would look like?