NotesSQL

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.
LVL 1
Neal HartmanAsked:
Who is Participating?
 
HemanthaKumarCommented:
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

0
 
HemanthaKumarCommented:
A typo, replace item with itm

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

0
 
Neal HartmanAuthor Commented:
One of is confused. I'm using NotesSQL and ADO though VB. Where do you get the object "doc".
0
 
Neal HartmanAuthor Commented:
Thank you, not what I was hoping for but answers the question.
0
 
zvonkoCommented:
Sorry :-)

Thank you for the points.
0
All Courses

From novice to tech pro — start learning today.