Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • 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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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