Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-14 Thread Preston
M Subject: Re: [sqlite] drop statement returns SQLITE_ERROR - Original Message - From: "Preston" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, October 14, 2005 1:21 PM Subject: Re: [sqlite] drop statement returns SQLITE_ERROR Here is the full sourc

Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-14 Thread Robert Simpson
- Original Message - From: "Preston" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, October 14, 2005 1:21 PM Subject: Re: [sqlite] drop statement returns SQLITE_ERROR Here is the full source to a stripped down version of the app i am truing

Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-14 Thread drh
"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > > > >This is probably an SQLITE_SCHEMA error. Rerun sqlite3_prepare() and > >sqlite3_step() and it should work the second time. > > > >This particular SQLITE_SCHEMA error seems unnecessary though. Looks > >like sqlite3_step() could probably do a

Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-13 Thread Preston Zaugg
"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > I have some updates to the schema of my sqlite database that i am trying to > apply. When i run these statements from the command line util they run fine. > when i run them from the API I get a SQLITE_ERROR on the statement that > drops a table.

Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-13 Thread drh
"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > I have some updates to the schema of my sqlite database that i am trying to > apply. When i run these statements from the command line util they run fine. > when i run them from the API I get a SQLITE_ERROR on the statement that > drops a table.