01-12-2021 08:08 AM - edited 01-12-2021 08:15 AM
Dear Labview programmer,
I have a problem with the reading of an SQL table. It would be great, if someone has time to help me with a hint. 🙂
My problem: I want to read all data or start reading at a certain ID. This is the code I use. Here I want to start reading at the ID 20205000.
(I use Labview 2016)
My SQL lite table (SQL file.png) starts with 0, 235, 195 ... at this ID. However,
Labview starts one row later with reading and writes in the row (one after the ID) NaN as a result (see probe 2.png).
I searched in the internet for an Idea, but unfortunately I can't find anything. It would be great if someone could help me. I tried diffeent start Ids and everytime it is the same behaviour.
Thank you in advance and stay healthy!
Best Stephanie
01-12-2021 09:28 AM
read all data or start reading at a certain ID.
If you want to start at a certain ID, why are you using "Greater Than" the ID in your select statement?
It should be "greater than or equal to".