Filling an array from recordset using Database Connectivity Toolset

[schmir1]

I would like to be able to read several columns from my database and copy the data to arrays. What�s the best way to do this? Take a look at my attached vi. I�ve wired up �Battery_Serial_Num� to test but really want the data in �Battery_Serial_Num Array�.

[David Duffey]

There is a pretty good picture in the Database Toolkit manual, on page 3-15. You'll need to simply pull out an array of variants, pull out the column you want, convert it to the data type you'll want, and then build an array buy enabling indexing on the edge of the for loop.