LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

ActiveX Acces

Hello,
does anyone can help me?
I use the Vi in joint, one for my data storage MS access
it already has the Fitre to select the table that you want to read, but I will like to know how added another filter to select another critere in the same table

 

thank you

0 Kudos
Message 1 of 9
(3,092 Views)
Don't use ActiveX for a database. Use.ADO as in theDatabase Connectivity Toolkit or free ones such as LabSQL.
0 Kudos
Message 2 of 9
(3,078 Views)

Thank you for your prompt response.
Can you help me about this ADO?
I am a beginner

0 Kudos
Message 3 of 9
(3,069 Views)
https://en.m.wikipedia.org/wiki/ActiveX_Data_Objects

The ADO interface provided from Microsoft is more generic and faster than the ActiveX interface to Access, which isn't even a database. You can use the same, or slightly modified code with all databases. You can purchase the toolkit from NI or do a search for free toolkits. I gave you the name of one.
0 Kudos
Message 4 of 9
(3,058 Views)

in my use, the base is very small given just 3 colone (brand / model / valor)
Have you an example of Vi for Labsql?

0 Kudos
Message 5 of 9
(3,047 Views)
LabSQL comes with examples.
0 Kudos
Message 6 of 9
(3,005 Views)

thank you very much
I tried to manage with

0 Kudos
Message 7 of 9
(2,977 Views)
You can also start here:

http://www.notatamelion.com/2015/01/05/managing-data-the-easy-way/

Mike...

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
0 Kudos
Message 8 of 9
(2,959 Views)

Also for me the best way is to connect to database with ADO by use Report Tooolkit or if you don't have LabSQl or you can create with the same procedure you used to create a DAO based vi's.

 

IN any case, your code have need (in DAO or in ADO both) to one times only to create connection to the database, use the filter by select case, and after you can close all reference to the database.

 

I've rebuild your code, you can duplicate the mutsibishi case to create the other choice.

 

 

Nicola
LabVIEW DeveloperByteLABS.
0 Kudos
Message 9 of 9
(2,950 Views)