Hello Simon, Clemens, and Richard, Thank you for your help.
> Simon: "What are you seeing from your SELECT that you weren't expecting ?" 0 | Batt 0 | ClockBatt 0 | Batt 0 | BP 0 | ORP 0 | Ref 0 | pH 0 | pH 0 | DO ... > Simon: "Can you reduce your INSERTs to just two rows, and still get results > you consider to be incorrect from the SELECT ?" Yes, I reduced the table to 2 rows by: DELETE FROM userparameter WHERE hepi_parameter_id !=32961 AND hepi_parameter_id != 32881; select (rtTableSort < 1000) as selected, abbrString from userParameter order by abbrString; results: 0 | ORP 0 | DO > DRH: "Can you try recompiling with all compiler optimizations turned off and > see if you still get the error?" I have turned off all optimizations (FYI: only C++ optimizations were on before) > DRH: ", can you compile with -DSQLITE_DEBUG then run the query *after* first > running "PRAGMA vdbe_debug=ON" and then send us the output?" I have been struggling to enable SQLITE_DEBUG with our uCOS-II VFS port. (namely our code does not have stdout or printf as compiled now. I love embedded;-) I'm working on a solution for debugging, more soon). > Clemens: "What is the EXPLAIN QUERY PLAN output for this query on the > handheld?" 0|0|0|SCAN TABLE userParameter 0|0|0|USE TEMP B-TREE FOR ORDER BY Thank you, Ken ken labar | Embedded Firmware Engineer Hach Hydromet | www.hachhydromet.com<http://www.hachhydromet.com/> | [email protected]<mailto:[email protected]> Innovating technology behind better data Please be advised that this email may contain confidential information. If you are not the intended recipient, please notify us by email by replying to the sender and delete this message. The sender disclaims that the content of this email constitutes an offer to enter into, or the acceptance of, any agreement; provided that the foregoing does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
