get data from database

[view_view]

For some reason I don't have the DB Tools Fetch Table Data.vi, I have the DB Tools Fetch Record Set Data.vi.  This vi doesn't seem to do what I wanted.  I just want to retrieve the data after the querry execution vi.

Thanks

[Underflow · Accepted solution]

Check in <LabVIEW>/vi.lib/addons/database/auxilliary.llb for DB Tools Fetch Table Data.vi.  It should return your results as a 2-D array of strings.  Be warned: it doesn't like nulls in the result set.

The DB Tools Fetch Record Set Data.vi returns your result as a set of variants, which must be converted to the correct type (presumably with the Database Variant to Data function).  If I recall correctly, it's a bit happier with nulls, but is slower due to wrapping and unwrapping results in types.

Joe Z.