An array is more of a programming data structure than a DBMS concept.
Typically, data elements might be read from a database (via query) into one
or more arrays, which may then be programmatically manipulated and then,
usually, the transformed data is either output using various methods
(screen, print reports, etc.) or entered back into the database via update
query.
As a data structure, an array is roughly analagous to a series of cells,
each of which is indexed for reference, and each of which (normally, though
not always) holds data of the same type. For example, one could use the
following declaration
Dim MyArray(10) as String
which would declare an array with cells for holding text (character string)
information. At any time one can access the contents of a cell using its
index; e.g. MyArray[6] returns the seventh element of the array (zero-based,
of course). One could then use program control structures to access each
cell by its index, thus
Dim i As Integer
For i = 0 to 9
TestStr = MyArray[i]
<<Do something with TestStr here>>
Next i
Hope this helps.
Cheers,
Scott
----- Original Message -----
From: "Joseph, Smile Poet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 5:46 PM
Subject: [wdvltalk] RE: Hosting cost - databases
> Cheryl, Matt, Stephen, Rudy,
>
> I've grasped that now; thank you all. Database is really the
> functioning environment for interpreting tables. I have taken a few
> faltering steps to writing code and understanding some terms but I
> will be asking next what is 'array'. Somehow I can't visualise what
> it is doing; is it within other queries, to set the layout of the
> replies, or is it just one form of query (as 'echo' establishes what
> is to be printed)?
<<::snip::>>
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
