[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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.
0
Neal Hartman
Asked:
Neal Hartman
  • 3
  • 2
  • 2
1 Solution
 
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
 
Neal HartmanAuthor Commented:
I'll try it out. How do you append or delete an individual
value. is this handled like a collection?

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now