Inserting an array into a DB

[san26141]

howdy -

I am using LV7.1 DB tools and I am trying to build a DB of different types of data.

Example data format

I have no idea how to insert the arrays into their respective field in the table. Would I decompose each 1D array into one long binary value and insert that into the field?

Thanks

David

[Michael Aivaliotis]

What you probably want to do is create a seperate table for the large array sets. This way you can perform searches and potential analysis on the data. Each element in the array will be a record consisting of the value and a key which will reference your single TblData entry.

[bburan]

What you probably want to do is create a seperate table for the large array sets. This way you can perform searches and potential analysis on the data. Each element in the array will be a record consisting of the value and a key which will reference your single TblData entry.

Agreed. However, it really depends on what you intend to do with the array. If you think you ever will want to search for or analyze individual elements in the array, Michael's suggestion is the best one. An alternative is to convert it to a "spreadsheet string" or some other format that can be parsed back into an array, and store that string in the field. This, however, makes it impossible to search or analyze the data in the array using SQL. I generally use both techniques in one project depending what I need to do with the data in the array.

[san26141]

So Data5 from above would become its own table something like this........

Thanks

David

[Michael Aivaliotis]

So Data5 from above would become its own table something like this........

Thanks

David

I'm not sure you're using PK in the right context. PK stands for Primary Key. I don't see how you can have data in there.

[san26141]

I'm not sure you're using PK in the right context. PK stands for Primary Key. I don't see how you can have data in there.

My 'misteak'....I guess it would be a ?foreign key?. I ran into a problem with the method mentioned above last night while trying to create the tables with the DB toolkit. Unfortunately MS Access does not allow tables with more than 255 fields and one of my tables would have 1024 fields. I am looking at different DB's but everyone here has Access...ugh! Can LV DB toolkit tie into other DB's like PostGRE or MySQL? It would be great to be able to search on individual elements of that 1024 table!

THanks

David

[Michael Aivaliotis]

My 'misteak'....I guess it would be a ?foreign key?. I ran into a problem with the method mentioned above last night while trying to create the tables with the DB toolkit. Unfortunately MS Access does not allow tables with more than 255 fields and one of my tables would have 1024 fields. I am looking at different DB's but everyone here has Access...ugh! Can LV DB toolkit tie into other DB's like PostGRE or MySQL? It would be great to be able to search on individual elements of that 1024 table!

THanks

David

Well, ya. You don't want to create fields. You want to create records (rows instead of columns). You probably only need 4 fields. Primary Key (autoincrement), Testrecord key (Tbldata entry key), Timestamp (if available) and datapoint value.

[san26141]

Well, ya. You don't want to create fields. You want to create records (rows instead of columns). You probably only need 4 fields. Primary Key (autoincrement), Testrecord key (Tbldata entry key), Timestamp (if available) and datapoint value.

THanks Michael...my bad....i don't have a very good understanding of DB's

Again Thank You,

David