labveiw with Mysql

[314159ym]

Hi 

I am using labview to read and write data with Mysql, i created some columns in Mysql table then i made the code in labview to query the table,problem is why i can not have the column at the front panel? Is the column should manualy type in at the front panel?

Some can give some advices thanks.

[bseguin · Accepted solution]

Any database will only return the data except if you explicitly request it. So I suggest you to use build array in the Array tool-set and add the title that you already have in a 1D array as a constant.

Benoit

[aputman]

---

@bseguin wrote:

Any database will only return the data except if you explicitly request it. So I suggest you to use build array in the Array tool-set and add the title that you already have in a 1D array as a constant.

Benoit

---

This won't always be possible especially if you are calling stored procedures or you are executing queries like "SELECT * FROM table".  This is where the recordset is useful.  In this snippet, I am executing a stored procedure, fetching the recordset data and grabbing the column names and datatype from the recordset.  Fetching the datatype will help with formatting the data later. 

[314159ym]

Hi 

Could you please send me this VI,then i can study

Thanks

[aputman]

I won’t be able to post anything until Monday. But all of the VI shown are in the database toolkit. The first one is Create Parameterized Query.  This one is a bit complicated but can be removed if you are executing a simple select statement.  Just duplicate the code shown and wire up an SQL statement to the Execute Query VI. The other VI is Get Recordset Properties. 

[314159ym]

Hi 

No problen i will wait,it is a fast way to learn if have some examples,meanwhile i will study the database toolkit

Thanks

[aputman]

See attached.

[314159ym]

Thanks