retrieving data from access database

[Joncombat]

Spoiler

I have a simple database called mydb.  I am trying to retrieve data from a table in the database called SN_data.  I am trying to retrieve a serial number (long int) from SN where ID = 1.  I can find the record but cannot display the data.  Is there a simple example that demonstrates retrieving data?

[RobertoBozzolo]

By searching in the examples with "SQL" keyword you will be prompted with several examples (readtab, readtab2, readtab3) that shows you alternatives to find and read records from a database. Readtab3, which uses random acces and maps, is probably the example that is more useful for your needs.

[Joncombat]

I have an example running.  Is it possible to run a query that is defined in an access database from CVI and obtain the results from it without generating the query in cvi?

[RobertoBozzolo]

I cannot answer on this as I'm not using MS Access databases.