Using the calander function to select and read tables data from MS access?

[Dennis_Knutson · Accepted solution]

No, the example does not save the query to access. The only time you would want a query stored in a database is if it was a stored procedure. Don't know if these even exist in Access.

Personally, I think the example is very 'friendly'. It uses events and a producer/consumer architecture and both of these are LabVIEW concepts that you should become used to. The examples that come with the database toolkit are pretty basic and you should start with those.

If you cannot perform a query on your database, then you should attach the mdb file and the query you are attempting to run.

[khsay87]

Thks. I got it. The sql commands allow me to retrieve all data and select data by comparision between time stamp 1 and time stamp 2. Can i change the SQL commands input so that i can display only only one coulum of data such as Temperature? 

would the SQL command be sumthing like this?

SELECT Test.Temperature, Test.Date_Test, Test.Date_Test
FROM Test
WHERE (((Test.Date_Test)>#5/1/2009# And (Test.Date_Test)<#5/31/2009#)); 

I would like to mention that previous i was using the Labview.mdb file which is found in the example folder. It was a 97 Access file which the queries VI cannot retrieve. Hence, I thought my concepts was wrong. i change it to using 2003 or 2007 Access and it work fine!

Message Edited by khsay87 on 01-06-2010 01:08 AM

[khsay87]

Hi dennis,

I receive this error prompt when i try to select the coloum. The error stuck at varient to data conversion block. Somehow the data cannot go thru the block diagram.

I had check the SQL command in MS access 2007. It is able to get the queries when i hit the button run.

Message Edited by khsay87 on 01-06-2010 03:37 AM

[khsay87]

thks dennis.

I had resolved my problem.