save data to mysql with labsql

[ni ci]

I am new to work with labview. I have a problem to save my measurement data into mysql using labsql.

Let's say I am measuring voltage from sensor with DAQ and I want to save this voltage to mysql using labsql.

Can anyone help me????????????? I need some example.

Thank You..............................................

[castech]

Hi,

Attached is a very simple VI that will read data from a table in mySQL. You need to modify the connection string to suit your database. There is also some example SQL on teh page that could be used to insert a record into a database.

I have used LabSQL quite a lot but always use the SQL Execute icon and build the SQL command string by concatinating the required syntax with teh values I want to write. Of course you can create a subVI that will allow you to pass in an array of column names and data (similar to the NI Database Connectivity Toolkit).

I hope this helps.

Cheers

Download File:post-7495-1168706374.vi