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? > > That has absolutely n

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: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 shoul

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

2011-10-04 Thread James Brison
e the Opening of the DB twice with no Close.   Thanks From: Roger Binns 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- Hash: SHA1 On 10/04/20

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 jus

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

2011-10-04 Thread James Brison
e 17 I want to check if the database is open before re-opening the database. From: Stephan Beal To: General Discussion of SQLite Database Sent: Tuesday, October 4, 2011 9:54 PM Subject: Re: [sqlite] How do you check if a sqlite database is open? On Wed, Oct 5,

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 open has succeeded, s

[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 http://sqlit