BrianSw Posted July 9, 2013 Report Share Posted July 9, 2013 I'm using Labview 7.1 with ADO Toolkit from ib-berger.com. I am using MS Access for the database. I have a table which uses several lookup tables to fill some of the fields in the Main table. When reading the table with the ADO toolkit the fields that are filled by the lookup tables return the indexes to the data rather then the actual data stored in the lookup tables. Other fields in the main table that don't use lookup tables display the correct data. Question is how do I get the actual values of these lookup tables rather then the indexes to the fields of the lookup tables? I am using the ADOtool_Select Data.vi with a SQL statement to get the results to fill a Labview table. Thanks for any help it is greatly appreciated. Brian Quote Link to comment
BrianSw Posted July 9, 2013 Author Report Share Posted July 9, 2013 I Guess Lookup tables are a Bad idea now that I understand what is actually going on. I'll have to try something else instead. Brian Quote Link to comment
drjdpowell Posted July 9, 2013 Report Share Posted July 9, 2013 Question is how do I get the actual values of these lookup tables rather then the indexes to the fields of the lookup tables? You need to do a “JOIN” of your lookup tables to the main table. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.