<div>
Assign the field value to a variant and then use forall to extract the multivalues.<br />
<br />
<br />
like this<br />
<br />
dim values as variant<br />
<br />
set itm = doc.GetFirstItem( &quot;Multivalue&quot; )<br />
values = item.Values<br />
<br />
forall v in values<br />
<br />
End forall<br />
<br />
~Hemanth<br />
<br />

</div>


Assign the field value to a variant and then use forall to extract the multivalues.


like this

dim values as variant

set itm = doc.GetFirstItem( "Multivalue" )
values = item.Values

forall v in values

End forall

~Hemanth



<div>
A typo, replace item with itm<br />
<br />

</div>


<div>
I'll try it out. How do you append or delete an individual <br />
value. is this handled like a collection?<br />
<br />

</div>


I'll try it out. How do you append or delete an individual
value. is this handled like a collection?



<div>
One of is confused. I'm using NotesSQL and ADO though VB. Where do you get the object &quot;doc&quot;.<br />

</div>


One of is confused. I'm using NotesSQL and ADO though VB. Where do you get the object "doc".


<div>
Thank you, not what I was hoping for but answers the question.<br />

</div>


Thank you, not what I was hoping for but answers the question.


<div>
Sorry :-)<br />
<br />
Thank you for the points.
</div>


<div>
<div class="content wysiwyg-content">
I am trying to use NotesSQL to read a multivalue field. NotesSQL, using VB and ADO, only returns the first value. I need to read all the values.<br />

</div>
</div>


I am trying to use NotesSQL to read a multivalue field. NotesSQL, using VB and ADO, only returns the first value. I need to read all the values.


NotesSQL

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.