When using numeric multivalue field, and setting the field with some values with
doc.replaceItemValue( fieldname, arrayOfNumbers ).
Then clearing the values with
doc.replaceItemValue( fieldname, “” ) or doc.removeItem( fieldname ) and setting the field with other values, OLD Values reappear !
Dim db As NotesDatabase, doc As NotesDocument,session As New NotesSession
Set db = session.Currentdatabase
Set doc = db.Unprocesseddocuments.Getfirstdocument()
Dim nums(2) As Integer
nums(0)=5
nums(1)=15
nums(2)=25
'Call doc.Replaceitemvalue(“numbers”, nums) 'before
Call doc.Replaceitemvalue(“numbers”, “”) 'after
Call doc.save(True,False)
Before After
Field Name: numbers
Data Type: Number List
Data Length: 28 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY
5
15
25 Field Name: numbers
Data Type: Text
Data Length: 0 bytes
Seq Num: 2
Dup Item ID: 0
Field Flags: SUMMARY