how to read or write 2D array from or to database

[seoul]

labsql or labview sql toolkit can only read or write 1D array one time. If i want to write 100 1D arrays to the database, it is too slow and will cost too many CPU time to do this by writing a single 1D array one time. :headbang:

So i wanna an efficient method. Can you help me?

[FZJ_Teststand]

Just a suggestion: Using LabSQL, you can use the SQL Exec Sub-VI. It returns an array of strings. So constructing an appropriate 'SELECT' command should meet your demands. For conversion of the array of string to a 2D array you can use the 'convert list of strings to array function' ...

[snooper]

Hi,

As far as I know it is not possbile to write a 2D array to a database Table directly. You are fixed to the 1 record insert.

But there are a few possibilities and tricks

-Switch to the ADO.COMMAND object to insert you data binary! This will decrease the size of your SQL command.

-Dont use new SQL commands for every record, try to use a "prepared ado.command execution"

-You might redesign your database to insert a 2D Array as an IMAGE datatype, but this will only be read/writable by LabVIEW.

Arnoud de Kuijper

T&M Solutions BV - Database Wizard