Search a value in a database and return all the valuesin a line of the table

[Nando88]

I want to be able to search a unique value in a table of an SQL database and if the value is found, I want to be able to return all the values in the row of the table in the database. I want to be able to manipulate each value in the row separately.

Can someone please give me an example, because I'm new to labview and I don't know how to do this.

[jcarmody]

Do you know how to make an SQL query in LabVIEW?  It sounds like "SELECT * FROM [a table] WHERE [a field] = "a unique value" will get your row.  What have you got so far?

[jcarmody]

I like to use the Execute Query function:

[jcarmody]

Today's fun fact - dropping this snippet on a Block Diagram crashes LabVIEW 2013 every time for me.  Does anyone else see this?

[RavensFan]

I don't have LV 2013 on this machine to test, but it did crash LV 2014 on me.

DAbort 0x1A7102DF in fpsane.cpp

That points to the front panel.  But one thing I find odd about your snippet is that the string constant is partially cutoff.  I thought the CCT would always grap the entirety of any selected objects.

[jcarmody]

I intentionally didn't select any of the string constant.

[Ranjeet_Singh]

Instead use select. In the coulms input you can mention coumns name you need. Output will be 2D array. Change and manipulate as per your requirement