[sqlite] SQLITE_SCHEMA error and pragmas

2005-07-16 Thread thatsanicehatyouhave
Hello, After some time, I've gone back to working with precompiled queries and found out why I was consistently getting SQLITE_SCHEMA errors. In my code, I was calling two pragmas after I compiled the query and before I executed it. Removing the pargmas removed the problem. The pargmas

RE: [sqlite] SQLITE_SCHEMA error

2004-01-02 Thread Bronislav Klučka
> Bronislav Klučka <[EMAIL PROTECTED]> writes: > > > PLIIZ HELP ME > > > >> > > I've read the documentation, where is written: "When the > database first > >> > > opened, SQLite reads the database schema into memory and uses that > >> > > schema to parse new SQL statements. If another process

[sqlite] SQLITE_SCHEMA error

2003-12-28 Thread Bronislav Klučka
I've send it two times, I'm sending it again, cause it's realy problem ::(, I hope somebody could know the answer Brona > > Really nobody knows? it's serious problem to me... > > Brona > > > > > Hi, > > I've got a problem. I'm accessing the database from two separate > > connection, > > one

[sqlite] SQLITE_SCHEMA error

2003-12-16 Thread Bronislav Klučka
Hi, I've got a problem. I'm accessing the database from two separate connection, one connection perform CREATE TABLE (DROP TABLE) statement and then the second is performing 'SELECT name FROM sqlite_master WHERE type="table";', this causes the SQLITE_SCHEMA (17) error, I've read the documentation,