How do i store an array of 500 in an db

[rikkemus]

Im making an access db, that is accessed through my VB 6.0 software. How would a clever way be to store this array in my database without making 500 rows in the table for it. Its 500 double values from a testsystem, that is used to draw a curve.

[Yulianto]

Save the array seperated by ",", like "array1,array2,array3,..... "

---

Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

[Colin Angus Mackay]

If it is an array of doubles used to draw a curve, all that encoding and parsing into and out of strings is going to slow things down. Probably better to use a varbinary or image field of some sort.

---

Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums