Solved

moving the columnvalues array into a VB array

Posted on 2004-10-12
4
287 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
[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
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

Technology Partners: 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!

Question has a verified solution.

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

Suggested Solutions

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.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

696 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