[sqlite] (no subject)

http://en.shijingsteel.com/pptlr.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error Message near ".": syntax error

Very embarrassing ... I had a typo after doing a copy & paste. Thanks All! From: Simon Slavin <slav...@bigfraud.org> To: James Brison <rman...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Saturday, O

[sqlite] Error Message near ".": syntax error

I am receiving the following error message when running a query against a sqlite db: Error Message near ".": syntax error What does this mean? and how do I debug it?  I'm new to sqlite and don't understand the 'near'.  Is it saying that I have syntax error somewhere involving '.'? Thanks

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

Thanks for the tips Roger. I'll use them to debug this Thanks James On Oct 4, 2011, at 11:23 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 10/04/2011 10:52 PM, James Brison wrote: >> Can you open a databa

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

- 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 just the prepare_v2 API and y

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

if a sqlite database is open? On Wed, Oct 5, 2011 at 6:48 AM, James Brison <rman...@yahoo.com> 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? >

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

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