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
