Re: [sqlite] prepared statement and database schema changed problem

2005-05-26 Thread Peter Hermsdorf
mhm, the problem is i have to store the "Query strings" somewhere, so that i'm able to prepare them again not nice, but OK. thanks for your answer. Dennis Cote wrote: Your call to sqlite3_step() is returning an SQLITE_ERROR result. The SQLITE_SCHEMA error code will be returned by the sq

Re: [sqlite] how to list table making a view

2005-05-26 Thread Peter Hermsdorf
are you looking for something like select * from sqlite_master; ? bye, peter Noel Frankinet wrote: Hello, Is there a better way to list all table making a view than parsing SQL. Is there an API ? I would like to show all table in a view (in a tree-view gadget). Same question for the table s

[sqlite] prepared statement and database schema changed problem

2005-05-26 Thread Peter Hermsdorf
hi, i'm using a DB base class which prepares some sql statements in it's constructor. a derived class creates additional tables in the same DB which "invalidates" the prepared statements in the base class (because of the schema change). After browsing the mailinglist i found an older discussio

Re: [sqlite] cross compiling for Linux running on an ARM

2004-10-12 Thread Peter Hermsdorf
hi, i had best results with the pre processed version of sqlite. this was with version 2.8. i haven't tried version 3 of sqlite yet. i compiled it under uclinux. greets, peter Richard Boyd wrote: I'm trying to run sqlite on Linux running on an embedded ARM processor on a development board.