Filling an array from a table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm sure this is fairly simple but I cannot find an example. I want to load
the records of a one field table into an array. The table contains only
dates and I already have all the code I need to compare the dates but don't
know how to load the array from the table.

Table - Holidays

1/17/05
2/12/05
5/30/05
etc....


redim Hol(Holidays.recordcount + 1)
For i = 1 to ? (Holidays.recordcount +1)
Hol(i) = record i of Holidays

next i

That is not the code I tried but pretty much what I need.
Thanks
Rich J


.

Relevant Pages

  • Re: fast stable sort
    ... For fastest load, at expense of slower sort, you ask the operating ... and you memory-map the file directly into that array. ... memory of your big array. ... possible to assure locality of reference and thus avoid thrashing ...
    (comp.programming)
  • Re: How can I create a 2D ArrayList? String usually.
    ... I basically would like a 2 column array or whatever that will be static, ... in values won't change after I load them and I would like to fairly quickly ... > Array.IndexOf is probably going to yield linear performance as you add ... you might be better off using hashtables. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: problem with [array get ...] -> file -> string -> [array set ...]
    ... I'm pulling my hair out trying to save and load data to a file. ... got a large array (probably filled with all sorts of "special" ... puts "saving test to test.save" ...
    (comp.lang.tcl)
  • Re: editing a mysql record using php and website ?
    ... And then when I hit submit I want to insert the new data into the ... If you KNOW its a single record, load the data into an array and then index the array into the text fields. ... echo "<input type='text' name='txtvendor' ...
    (comp.lang.php)
  • Re: Skipping bytes while reading a binary file?
    ... numbers where the first 32 bits of the file is the real component, ... I'd like to be able to read in just the real components, load them ... time-consuming are the simple assignment statements in the ... but at some point I'll need to split this array ...
    (comp.lang.python)