During the recent development of an inventory system using LabVIEW and MySQL DB, I ran into an issue. When using the Create Table Vi, used the a constant off of the columns terminal which produced an array of clusters containing 4 elements. One of which was the data type. However, when creating the table, MySQL would complain about the incoming data types. In order to mitigate this I created an enum that contained data types as listed by MySQL, which remedied the problem.
Has anyone else ever dealt with a similar situation? If so, why does it occur? And how did you go about remedying the issue?
Many thanks for any responses.
Creig Mills
Culverson Software - Elegant software that is a pleasure to use.
Culverson.com
Blog for (mostly LabVIEW) programmers: Tips And Tricks
