http://en.shijingsteel.com/pptlr.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
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
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
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
: 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