Function sqlite3_last_insert_rowid always returns 1. I have compiled SQLite for ARM big endian mode using the gcc ARM compiler.
I have also compiled SQLite for the Axis ETRAX RISC processor. The two platforms we are using are the Linksys NSLU2 (the unslung firmware) and Acme systems FOX Board: http://www.nslu2-linux.org/wiki/Unslung/HomePage http://www.acmesystems.it/?id=4 Could this be an endianess and/or bitmasks problem? I used the following flags when compiling for NSLU2: -DNDEBUG -DSQLITE_ALLOW_XTHREAD_CONNECT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -O3 -fno-common -DPIC The above compiler flags was generated on a host computer (my mac) by running: configure --disable-tcl --enable-static --enable-threadsafe --enable-cross-thread-connections Compiling the same code on a standard Linux X86 and Mac PPC using the same flags work without any problems. Regards, Wilfred _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
