Arrays in MS Access Tables

[Dinobrago]

I have an array of real numbers (actually, a series of x,y coordinates that make up a plot) that I need to store in an Access table. I suppose I could store it as a string with comma separated values but that means I have to parse it after I read it. Any suggestions? Any help would be appreciated.

 

[KenReay]

Hi

If the series of plots is ABSOLUTELY fixed in number what is wriong with just having a series od columns called (say) X1,X2..etc. If you want to iterate through them array style this can be done with a for loop so

For i = 1 to 9
Rs("x"& i) = 0
Next i

If the series is not fixed in number save each plot in its own row so

TblPlots

PlotId ) Prime
CordNo ) Key
X
Y

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[MichaelRed]

Hmmmmmmmmmmmmmm,

WAY to little info to really give advice here, but why not just a plotid (identify what "plot" the point belongs to, and individual Xpos, YPos (Single) values?

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Dinobrago]

Basically, this is a database of spectra where each spectra might have a broad range of points. There will be about 10-20,000 spectra to start. Some spectra may have as few as 10 (x,y) points to as many as 1000 points. For each spectra there is a set of associated textual and numerical data. Definitely not fixed amounts.

Rather than having the x,y data separate, I would like to have it in a table or set of tables, less for performance than security issues.

Dean
goddette@san.rr.com

 

[KenReay]

Hi

In that case my second example holds good

If the series is not fixed in number save each plot in its own row so

TblPlots

PlotId ) Prime
CordNo ) Key
X
Y

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[MichaelRed]

I disagree w/ kenreay.

Place the individual points ([X] and [Y] in a single record with the [spectra] (or set Id). Make a second related table with [sprctra] and the text info.

So, a given spectra would have as many records (rows) as there are points in the point table, but only one record in the table which includes the text info re the spectra.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[KenReay]

Hi Michael

We are at cross purposes here - you are not disagreeing with me, - you are saying the same as me, but using the column names given in the later post.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[MichaelRed]

save each plot in its own row

seems to be at odds with your structure. Further, you do not address the additional 'text' information.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Dinobrago]

Thanks! This has been a great help.

Dean
goddette@san.rr.com