Solved

NotesSQL

Posted on 2002-03-11
7
295 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
Independent Software Vendors: 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!

 
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 200 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus notes send email with attachments 8 174
VBA Lotus notes 2 211
How to connect (using VBA) to a IBM Notes webmail server 3 270
Adding a named anchor in a Lotus Notes Form 6 106
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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.

737 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