Kees, thanks. I reopened the connection and all is OK now. thanks for your help,
gert 2012/10/24 Kees Nuyt <k.n...@zonnet.nl> > On Wed, 24 Oct 2012 15:53:39 +0200, Gert Van Assche > <ger...@datamundi.be> wrote: > > >All, hoping you can help me. > > > >I bumped into an "SQL logic error or missing database" error and I don't > >have a clue why this happens. > >It happens on the first action I take in a series of all the same actions > >(updates of a table). > >I removed the triggers, changed the indexes, checked integrity... still > >this error. > > > >the strange thing is that when I copy the command that triggers this error > >message to the clipboard and execute it at that time on the DB, the error > >does not occur. > > > > Does anyone have an idea what might cause this > > Hard to tell without looking at the actual code. Perhaps the > path/filename in your _open() statement is not correct (does not point > to the same file as the command line does), or the open flags/URI > arguments conflict with the databasefile. > > > or how I can detect why this > > is happening? > > Check the return values of all API statements, like _open_*(), > _prepare_*(), _bind_*(), _step(), .... > to pinpoint where an error first occurs. > > And as usual: Reduce your code to the minimum needed to reproduce the > problem and post it here. > > > > >thanks > > > >gert > > -- > Groet, Cordialement, Pozdrawiam, Regards, > > Kees Nuyt > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
