I am using the VI "DB Tools Select Data" from the database connectivity toolset. And I have a problem with the VI "DB Tools Execute Query" that is included. I would like to select a specific column from a specific table in my database and it is ok so long the name of the table is just one work, example "Names", but if the name of the table consists of two words ("Last Name") I get error, the message says that it can't find the table Last, i.e. not the whole string is read, just the first part. How can I manage to get the "Conn Execute.vi" to read the whole SQL query? Any suggestions?
As far as I know and what I experienced, there are no blanks allowed (and some other special characters), both in table names and column names.
Just replace the blanks with an underscore and it should work.
Using LV8.0 -------------------------------------------------------------------- Don't be afraid to rate a good answer... 😉 --------------------------------------------------------------------