Reading from the Database

[Glen]

Can anybody give a rookie a detailed example on how to read the value
from the database by criteria.
I've been trying to use ActiveX. No problem using DoCmd.RunSQL to
write to the database. However, no any known method, like DoCmd.RunSQL
"Select...." or opening the recordset does return a value.
And no, I do not have LabView SQL Tool, and no, I do not want to spend
additional $500 to purchase ANYTHING else. It is my understanding that
LabView MUST have a standard ways ( maybe not as straight as with the
SQL tool ) to read a value from the database.
Thank you for the help!

[Dennis_Knutson]

Jeffrey Travis has started L.O.S.T. (LabVIEW Open Source Tools) and one of the first tools he has created is LabSQL. This uses an interface to ADO to issue SQL commands. You can download it from http://www.jeffreytravis.com/lost/.

[aderogba]

I've tried to use Jeffrey's L.O.S.T. but I keep getting "SubVI is not executeble" error. Please do you know what's responsible?

[Dennis_Knutson]

Which subVI and what is the error for the bad subVI? What version of mdac/ado do you have on your system? What OS are you using?

[aderogba]

1. SubVI: Example-Fetch a Table.vi
2. Error: 'Example-Fetch a Table.vi' is not executable
SubVI's within this VI have the same error as well
3. ADO Version: Microsoft ADO 2.1
4. OS: Windows NT 4.0 SP5
Thanks

[Dennis_Knutson]

Keep clicking on the broken VIs until you get the detailed error. I suspect that you'll have to go down a ways until you get to ActiveX stuff.