[sqlite] (no subject)

2012-06-27 Thread James Brison
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

2011-10-09 Thread James Brison
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, October 8, 2011 7:06 PM Subject

[sqlite] Error Message near .: syntax error

2011-10-08 Thread James Brison
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?

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 rog...@rogerbinns.com 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

[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

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

2011-10-04 Thread James Brison
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? An app cannot use an sqlite3 handle unless

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

2011-10-04 Thread James Brison
: 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 you won't get schema