Hi! I have some problem with running sqlite on board with arm7 processor under QNX6.3.0 (flash filesystem) Library and command shell (sqlite3) were compiled on self-hosted (x86-pc), gcc 3.3.5, qnx neutrino 6.3.0
#configure --host=arm-unknown-nto-qnx6.3.0 #make CPU:ARM Release:6.3.0 FreeMem:10Mb/16Mb BootTime:Mar 07 09:24:07 UTC 2006 Processor1: 1098936834 arm720 74MHz running sqlite3(command shell) on arm-board log: ---------------------------------------------------------- # sqlite3 /var/test_base SQLite version 3.3.4 Enter ".help" for instructions sqlite> create table TEST_TABLE (A integer, B integer, primary key (A)); sqlite> insert into TEST_TABLE (A,B) values (1,2); sqlite> insert into TEST_TABLE (A,B) values (3,4); sqlite> select * from TEST_TABLE; 1|2 3|4 sqlite> select * from TEST_TABLE where (A>0) order by A; SQL error: database is locked sqlite> insert into TEST_TABLE (A,B) values (5,3); sqlite> select * from TEST_TABLE order by B; SQL error: database is locked sqlite> .quit # # ls -l /var total 0 -rw-r--r-- 1 root root 0 Mar 07 14:39 test_base # ---------------------------------------------------------- 1) SQL error: database is locked - what does it mean ? 2) why /var/test_database have zero-size after quit ? And one more feature: I wrote a test program (C), which do insertion of two records into test_table, and "select * from TEST_TABLE order by A;", i got an error : code=1 what=SQL logic error or missing database Any advise ? -- View this message in context: http://www.nabble.com/Probleb-with-running-3.2.7-and-3.3.4-under-qnx6.3.1-%28armle%29-t1240122.html#a3281991 Sent from the SQLite forum at Nabble.com.
