Database

[josorio]

Hello
I am currently programming a LabView Aplication (ver 6i) using the Database connectivity Toolset. My database is microsoft access.

I have two question:

1.- In order to get the number of row in a table I write the sql sentence select count(*) from table. How can i get the result of this query. I am trying to use the exe function include in the tool kit.

2.- My second question is. How can I update, delete records from a table that I want protect by password. I allrready try using the parameters User ID and Password availables in the DB tools open connection, but this does not work.

Thank in advance

[csch]

Hello,

I can give you an answer for your first question.

I attached a VI which gets the number of rows of an Access table. Since it is a National Instruments database example, you should have this Access database installed on your system. See explanation on the VI front panel.

I hope it will help you.

[Christopher Mitchell]

Do you have a username and password configured for the database through the ODBC config utility or through the UDL? You should not be able to update the database if you do not specify username/password in the VI.

[PIPELON]

I NEED SINCE TO GET DATABASE CONNECTIVITY TOOLSET I DON'T HAVE A THOUSAND DOLLARS TO BUY IT AND IT IS HIGH-PRIORITY TO CONCLUDE MY UNIVERSITY THESIS.

I PLEASE REQUEST SINCE THEM THEIR HELP OF THIS IT NOT DEPENDS MY PROFESSIONAL FUTURE AND MY UNIVERSITY THIS IN CAPACITY TO CARRY OUT THIS PURCHASE.

THANK YOU.

[Dennis_Knutson]

If your university doesn't have it, them you might want to try LabSQL from http://www.jeffreytravis.com/lost/labsql.html. You will have to learn a little about the SQL programming language but the tool is free. This and the NI toolkit are both based on ADO but the NI toolkit has a lot of high level functions that hide some of the complexity. I've used LabSQL quite a bit.

And please turn off caps lock on your keyboard.

Message Edited by Dennis Knutson on 10-10-2006 10:19 PM

[PIPELON]

Mr dennis.

I Knowing of the existence of the tool LabSQL and I have it, I would like it collaborated me with a small doubt that I have with this tool.
In these moments I am carrying out a simple project that it consists on an optic barrier that begins the count of time when being interrupted by an athlete and in the same way when it crosses it the time again for.
In fact the hardware is quite simple, but the magic of the project is since in the software this carries out the complete analysis of the acquired different data.
The fact of this message consists on asking to you that way sends an array that is composed from numeric different data to a database carried out in MS acces and if it is possible and it is not nuisance for you I could give a simple example.

Very grateful for your attention.

[Dennis_Knutson]

Okay. I created an Access database called LVExample.mdb with a table called table1 with auto-index column as a primary key and a column called Measurement set for dbl datatype. I then went to the ODBC Administrator and created a dsn called 'test' that pointed to the database. The attached example program has an array of doubles that is inserted one by one into the database.

[PIPELON]

Mr. Dennis.

When I Try The Example That You Send Me To Open Up, A Message That Says Appears:

"In Build Application, This Might Be Because The Saw Being Loaded: Or Was Last Complied For To Different You, In Which You Marries Need To Save The I Saw On The Current Platform.
Or Is To Polymorphic Vi, Wich Dog Not Be Loaded In.
An Error Occured Loadin Vi 'Labsql Array Insert Example.Vi.
Labview Lauds Error Code 11: I Saw Version (7.0) Cannot Be Converted To The Current Labview Version (8.0) Because It Has Non Block Diagram."

Mr. Dennis If It Is Possible I Could Send The File Again Corrected Since I Have Windows Xp And Labview 8.0

Thank You.

Juan Felipe.

[Nishant]

Dear Dennis,

          Can you send this LabSQL Example.zip for LabVIEW 7.1 version?

Thanks,

Nishant

[Dennis_Knutson]

I apologize for this. I must have hit development distribution instead of development. Here's the llb.