?
Solved

NotesSQL

Posted on 2002-03-11
7
Medium Priority
?
297 Views
Last Modified: 2013-12-18
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
Comment
Question by:Neal Hartman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6855678
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
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6855680
A typo, replace item with itm

0
 
LVL 1

Author Comment

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

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:Neal Hartman
ID: 6856623
One of is confused. I'm using NotesSQL and ADO though VB. Where do you get the object "doc".
0
 
LVL 10

Accepted Solution

by:
zvonko earned 800 total points
ID: 6857945
0
 
LVL 1

Author Comment

by:Neal Hartman
ID: 6858007
Thank you, not what I was hoping for but answers the question.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6858015
Sorry :-)

Thank you for the points.
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question