SQLite Timestamp example not working on NI Linux RT target

[TiTou]

Hello,

The "Timestamp" (~\LabVIEW xxxx\examples\drjdpowell\SQLite LabVIEW\SQLite Timestamps.vi) example that ships with SQLite package (I have the latest version available via VIPM) doesn't work on NI Linux RT. It runs just fine on Windows.

After some digging, I saw that the latest SQLite 3 version available via opkg update is 3.22

It turns out that to run properly the Timestamp example vi uses features (Tgen) that require SQLite 3.31 at least.

And the version of the sqlite3.dll that comes with SQLite package is 3.32, hence why it runs on Windows.

So I got the source code from SQLite.org for v3.34

copied it to my Linux RT target and follow the instruction given here by jtagg - 🙏 - to compile and install sqlite3.34

After doing that the Timestamp example vi works just fine on NI Linux RT

😌

[TiTou]

If you want NI to update the SQLite version available via opkg, vote here.