[sqlite] SQLite + uSQLite

ite server itself? Thanks for your help. Take care, Julien -- -------- Julien LEFORT Com2gether 16, Allée de la verte vallée 14000 CAEN tel : +33 2 31 15 61 42 fax : +33 2 31 53 76 14

[sqlite] uSQLIte admin

able. Thanks Julien -------- Julien LEFORT Com2gether 16, Allée de la verte vallée 14000 CAEN tel : +33 2 31 15 61 42 fax : +33 2 31 53 76 14

Re: [sqlite] limiting table size?

eight > 9|nine > 10|ten > 11|eleven > 12|twelve > 13|thirteen > 14|fourteen > 15|fifteen > > For either case, the fifo table can eventually exhaust the available id > values (after a very long time because of the 64 bit id values). If this > happens you will receive an SQLITE_FULL error when you try to do an > insert (because of the autoincrement constraint on the id). When this > happens you will need to run the following update to reset the lowest id > to 1 before repeating the failed insert. > > update fifo > set id = id - (select min(id) - 1 from fifo); > > HTH > Dennis Cote -- Julien LEFORT Com2gether 16, Allée de la verte vallée 14000 CAEN tel : +33 2 31 15 61 42 fax : +33 2 31 53 76 14

[sqlite] [SQLite] Trigger on multiple actions

Hi, is it possible to have a trigger as follow: CREATE TRIGGER trigger AFTER INSERT, UPDATE, DELETE ON table BEGIN ** END; Thanks Julien -- Julien LEFORT Com2gether 16, Allée de la verte vallée 14000 CAEN tel : +33 2 31 15 61 42 fax : +33 2 31 53 76 14

[sqlite] ring buffer table

. Is there any way to declare this table with these properties included, so I don't have to add code to do this function? Thanks Julien Julien LEFORT Com2gether 16, Allée de la verte vallée 14000 CAEN tel : +33 2 31 15 61 42 fax : +33 2 31 53 76 14

[sqlite]cross compiling with powerpc

Hi, I've been struggling for few hours trying to run the configure script the right way so I can cross compile sqlite3 for a powerpc target. I guess it is only a problem of options I pass into the configure script. here is the command I pass: CC=powerpc-linux-gcc CXX=powerpc-linux-g++