dynamic data to database

[Rolando-stc]

Hi, I'm trying to send dynamic data to a database in microsoft access, but I'm having troubles becuase no matter how many points I send it always appears the same number in my database.

I'm new in all this database with labview and I can't figure out how to send all the points of my dinamic signals.

Greetings and thanks!!!

[jcarmody]

I'm thinking that your problem lies in the fact that you're converting your dynamic data to a single scalar.  The Simulate Signal Express VIs make the same data each time you run them, and you're only taking (the same) one point from all of it.

[Rolando-stc]

Thanks for replying jcarmody.

The problem is when I convert the dynamyc signal to an array, the database can´t read it because only accept strings and I don't know how to make my database read that array.

[jcarmody · Accepted solution]

My first thought was to write each point in a For Loop, like this:

 (by the way, attach your VI next time)

My next thought was to convert the array into a spreadsheet string and store one waveform measurement in one database record.  I expect this would be faster because there's only one SQL INSERT happening.

[Rolando-stc]

thank you so mucho jcarmody, it works perfectly 🙂

[jcarmody]

You're welcome.  Which one?

[Rolando-stc]

the first one because the second one also gave me all the values but in a single cell

[Yamaeda]

You should be able to modify JC's first to build 1 query instead of inserting line by line, assuming the total isn't too long. You can also simplify it slightly by using the Insert-vi.

/Y