I am just getting started with databases. I am trying to use the "DB Tools Insert Data.vi". I put my data into a cluster, and pass the cluster into the VI. When the data comes out of "DB Tools Parser.vi" the parameter names are missing. What am I doing wrong?

I'm not sure if spaces are allowed in a query like that (hence why I don't like them). They would still be my first suspicion. My second would be that you have a reserved keyword in there somewhere, but I don't see anything that pops up at me. My third would be that that's not the proper syntax for an INSERT statement, but it probably is. You should verify. As a practical suggestion, I assume that whichever DB you're working with also has some kind of front end (SQL Server Management Studio, MySQL Workbench, SQLite Manager, Access, etc.). If it does, you can usually use that to generate a valid INSERT query and see the exact structure that it uses.

LabVIEW

DB Tools Parser

Solved!

Author

Hi Yamaeda,

Yes, that's what I did. It is a database that was generated with M$ Access, and I didn't realize that it would allow names that SQL can't use. I was trying to use the toolkit to save time, as it has been 10+ years since I last used SQL, but I have dusted off my O'Reilly book and will write myself.

Jim

LV 2020