SQLite's DATE() function works on text formats, including the text format this library can write, but not the Blob format (which is the LabVIEW binary timestamp).
You can easily search by time by calling
SELECT COUNT(*) FROM Results WHERE LVTime>=? and LVTime<?
and binding the two end times. Bind the end times with the same format that LVTime uses.
Hi Max,
The actual bug, I think, was that “Step.vi” was ignoring errors outside of 1..99. It has a case structure that only passes those codes to the error-handling subVI (written, originally, because 100 and 101 are not errors). I have changed it so that the extended error codes are now passed (see version 1.7.3 just added to the LAVA CR). I tested it by making a foreign key error and it now works.