Solved

NotesSQL

Posted on 2002-03-11
7
290 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
  • 3
  • 2
  • 2
7 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
Comment Utility
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
Comment Utility
A typo, replace item with itm

0
 
LVL 1

Author Comment

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

0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 1

Author Comment

by:Neal Hartman
Comment Utility
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 200 total points
Comment Utility
0
 
LVL 1

Author Comment

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

Expert Comment

by:zvonko
Comment Utility
Sorry :-)

Thank you for the points.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now