RE: Working with Arrays

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks, that helps a lot. Unfortunately knowing that didn't help me
understand the next part of my proc. What I am doing is trying to dump the
array into an excel sheet range. I'm getting the array fine and when I look
at it in the immediate window it looks the way I would expect but when I dump
it into the range using formulaArray I get a type mismatch error. I'm
thinking that the shape/size of my range isn't matching the shape/size of my
array. Any idea how I can test this?

The other thing that I noticed that I didn't understand is that the array
I'm building is filled with the results of an sql string that is just a dump
of everything in a table. The table has 29 rows but my array only has 28.

Thanks,

m
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office


"Klatuu" wrote:

> the ^ is an expotential operator. in means in this case raise the value of 2
> to the 15th power which will return 32768
> So, the GetRows method will return up to 32768 rows depending on whether it
> hits EOF before that number of rows is returned.
>
> "MJatAflac" wrote:
>
> > Good morning,
> >
> > I am trying to modify some existing code to suit my purpose. This is the
> > first time I've worked with an array so I'm experiencing some difficulty and
> > I was wondering if someone out there can answer a couple of questions for me.
> >
> > I believe this code:
> >
> > Dim MyArray(10, 10) As Integer
> >
> > Would give me an array of integers 11 rows by eleven columns
> >
> > But I have this code in my Proc and don't understand what it's doing:
> >
> > varResults = rstPQA.GetRows(2 ^ 15)
> >
> > I know it's taking the results of a query and loading them into an array but
> > what does the (2^15) do?
> >
> > I have other questions but I think if I get the answer to this one it might
> > answer the others.
> >
> > Thanks in advance for your help,
> >
> > Michael Joyce
> > --
> > Michal Joyce
> > Project Management IS Analyst
> > Aflac - Project Management Office
.

Relevant Pages

  • Re: Ruby Newbie...Classes and Objects, oh my!
    ... one text file and dump each line into an array. ... file and dump that into a string. ...
    (comp.lang.ruby)
  • Re: Handling ubound on an uninitialised array
    ... I'd forgotten about the array dump to range - that's a nice feature. ... > the variable must a declared as a variant not a variant array, ... > 'NOTE REDIM PRESERVE BOTH BOUNDS WORKS FOR A 'PLAIN' VARIANT ONLY ...
    (microsoft.public.excel.programming)
  • Re: Ruby Newbie...Classes and Objects, oh my!
    ... one text file and dump each line into an array. ... file and dump that into a string. ... def initialize ...
    (comp.lang.ruby)
  • Re: Ruby Newbie...Classes and Objects, oh my!
    ... one text file and dump each line into an array. ... file and dump that into a string. ... uninitialized for that matter ...
    (comp.lang.ruby)
  • Re: Standards compliance
    ... >Which can be trivially avoided by not making the array static. ... the compiler can no longer perform the optimisation. ... even when looking at a dump of the whole ... Thanks for the suggestion on using the source file name as the ...
    (comp.lang.c)