Solved

moving the columnvalues array into a VB array

Posted on 2004-10-12
4
280 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
Comment Utility
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
Comment Utility
Please post your relevent code.
0
 

Author Comment

by:skintpaul
Comment Utility
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
Comment Utility
Actually, that's the way it is handled in LotusScript as well.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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…
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.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 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

12 Experts available now in Live!

Get 1:1 Help Now