Re: [sqlite] How do you check if a sqlite database is open?

2011-10-05 Thread James Brison
Thanks for the tips Roger. I'll use them to debug this Thanks James On Oct 4, 2011, at 11:23 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 10/04/2011 10:52 PM, James Brison wrote: >> Can you open a database twice without closing it? >

Re: [sqlite] How do you check if a sqlite database is open?

2011-10-05 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/2011 10:52 PM, James Brison wrote: > Can you open a database twice without closing it? That has absolutely nothing whatsoever with what you are seeing. > What is odd, is that I am using the prepare_v2 API. The documentation says > it

Re: [sqlite] How do you check if a sqlite database is open?

2011-10-04 Thread James Brison
the Opening of the DB twice with no Close.   Thanks From: Roger Binns <rog...@rogerbinns.com> To: sqlite-users@sqlite.org Sent: Tuesday, October 4, 2011 10:38 PM Subject: Re: [sqlite] How do you check if a sqlite database is open? -BEGIN PGP SIGNED MESSAGE

Re: [sqlite] How do you check if a sqlite database is open?

2011-10-04 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/2011 10:35 PM, James Brison wrote: > I am receiving a SCHEMA_ERROR, I believe this is happening because the Master > doesn't close it's connection before the Detail re-opens the db. Huh? What would lead you to believe that? In any event

Re: [sqlite] How do you check if a sqlite database is open?

2011-10-04 Thread James Brison
to check if the database is open before re-opening the database. From: Stephan Beal <sgb...@googlemail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, October 4, 2011 9:54 PM Subject: Re: [sqlite] How do you check

Re: [sqlite] How do you check if a sqlite database is open?

2011-10-04 Thread Stephan Beal
On Wed, Oct 5, 2011 at 6:48 AM, James Brison wrote: > Does anyone know how to check if a sqlite database is open? I know > sqlite3_open method is used to open the database but is there a method to > check if it is already open? > > An app cannot use an sqlite3 handle unless

[sqlite] How do you check if a sqlite database is open?

2011-10-04 Thread James Brison
Does anyone know how to check if a sqlite database is open?  I know sqlite3_open method is used to open the database but is there a method to check if it is already open? Thanks, James ___ sqlite-users mailing list sqlite-users@sqlite.org