Storing an array in a SQL Server Record

[txgeekgirl1]

Is there a way to store an array in a SQL server record such that elements can be retrieved using array indexes rather than having to specify specific fields in a built DB.

 

[simian336]

If I remember correctly Foxpro had an array field. I have not seen an equivalant in SQL Server (but I have not been looking for one either).

Out of curosity why?

Simi

 

[txgeekgirl1]

I think that is why my boss thinks it's possible - we do a lot of FP coding.

We are looking to write a database but have to use a web interface and my boss thinks the easiest way to gather the data would be to have an array dump so he doesn't have to write field to field.

 

[simian336]

There is no school like the old school, but it might be time to look forward.

: )

Simi

 

[markros]

FoxPro has arrays, but it doesn't have it as a field type. Actually, many languages have arrays.

In .NET you can get data into a DataReader and access them by ordinal number.

PluralSight Learning Library

 

[TonHu]

An array should be moved/converted to a table. Anything else is a design error!

Out with the old, in with the New And Improved.(r)