urgent help please ! Get data after executing query

[Cadbury]

Hi all

I have stored some data's with labVIEW to mysql by writing query using db tools execute query.vi.

For fetching those data's also wrote a query(select* from....)using the same tool . 

the query got executed . What tool i have to use to retrieve the data from mysql to a labview array.( the fetch recordset data.vi tool is not fetching.)

Thanks

[tbob]

First, make sure your query string is correct, no typos, the table and fields exist.  If all of this is correct, try using Fetch Next Recordset instead of Fetch Recordset.  I've had to do that with some databases.  For some reason, the record pointer doesn't advance with the query.  Or maybe the record pointer is pointing to empty space and the query places the record found as the next record instead of the current record.