-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Gallery
Posts posted by Landert_SCHJ
-
-
On 7/10/2020 at 4:56 PM, drjdpowell said:
Here is a beta version, that you can test if you like:
drjdpowell_lib_sqlite_labview-1.12.0.89.vip 4.36 MB · 7 downloads
It's not implemented exactly the same way as your example, but it should work in the same places. See the example "SQLite Parameters in Execute".
In the meantime this ist the official version though. I'm trying to run some of the examples you made "SQLite Parameters in Execute.vi" and "... Timestamps.vi" on my Industrial Controller IC-3120, running Linux RT but they require quite big changes. Before I get into all the SQL programming I want to make sure that I can use this library on my realtime target with large clusters (as your example shows well enough). My question is now if the problems I have could be due to LV2017 or how else I can find out which SQL commands work on the target and which don't? I used the ni packages opkg install sqlite3 which installed libsqlite3.so.0 and ...0.8.6 (both don't work with the unchanged example).
[CR] SQLite Library
in Code Repository (Certified)
Posted
The error from example "... Parameters in Execute.vi" was due to a whitespace in the CREATE TABLE section:
CREATE TABLE IF NOT EXISTS Log (Time, Value,Note);
didn't work
CREATE TABLE IF NOT EXISTS Log (Time,Value,Note);
works now. Apparently Linux is sensitive to whitespace... And YES, removing the generated column did also solve for the problem in the "...Timestamps.vi" Example.
Thank you!! I would never have expected to get solved this issue today! Now I have to get into SQL, this will take probably more than half a day 😬.
For your information: To run the examples on a RT target, apart from the problems discussed, one has to remove the file dialog VI with a path "/home/lvuser/Parameters Example.db" for example, where you have write access from the application.