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
Solved

moving the columnvalues array into a VB array

Posted on 2004-10-12
4
286 Views
Last Modified: 2013-12-18
Hi folks
I'm writing a VB app that loops through the documents in a Notes view as follows and moves the values in the view into a variant array using .ColumnValues
    While Not oDoc Is Nothing
        Dim s() As Variant
        s = oDoc.columnvalues
        'manipulate s here
    Wend

However when it comes across views that contain saved conflict documents it does bizarre things like creating a 2d array for certain fields
ie. my array s when there is no conflicts
s(0)  = "blah"
s(1) = "blah"
s(2) = "blah"
s(3) = "blah"

with conflicts it might load up my variant array as follows
s(0) = "blah"
s(1) = "blah"
s(2)
s(2)(0) = "blah"
s(3)  = "blah"

I however dont know how to handle this as, if I refer to s(2)(0) each time, then my program will crash when it doesnt have a value ?
and s(2) on this occasion doesnt have a value

I hope this makes sense

Any help appreciated
Paul

0
Comment
Question by:skintpaul
4 Comments
 
LVL 15

Accepted Solution

by:
Bozzie4 earned 300 total points
ID: 12286531
Well, that's because the columnvalues in theirselves can be arrays too.

Isn't there something like a normal variant in VB ?  Try
dim s as variant

This should create a variant, of type array, with values of type variant too (that can be arrays themselves)

cheers,

Tom
0
 
LVL 19

Expert Comment

by:RanjeetRain
ID: 12286651
Please post your relevent code.
0
 

Author Comment

by:skintpaul
ID: 12286772
Folks
I found the answer. I'm going to use ISarray(s(x)) to determine how to handle each item of the array.

Thanks for your efforts. I have another question that I'm about to post regarding Notes View Column names

Paul
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 12290757
Actually, that's the way it is handled in LotusScript as well.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus Domino Server 9 4 93
Lotus Notes Database - Include button in Email Notification 8 66
Migration Lotus to Exchange 2016 4 187
Cannot access mail archive from IBM domino 5 108
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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