As a follow up...
Sqlite finds the first db fine useing a relative path but the ATTACH command
needs the FULL PATH. Ugg!
Are you sure it's really opening the DB you think it's opening? I think
SQLite will create the file if it's not there, and you'll have nothing in
it.
Perhaps you should
IIRC, there's a connection string option that will choose between creating an
empty database and throwing an exception if you try opening a database that
doesn't exist. Perhaps if that option is set to throw an exception, then the
ATTACH command would fail. Or not.
RobR
On 29 Feb 2012, at 6:07pm, Rob Richardson rdrichard...@rad-con.com wrote:
IIRC, there's a connection string option that will choose between creating an
empty database and throwing an exception if you try opening a database that
doesn't exist.
Arguments to sqlite3_open_v2():
I'm attempting to do a test accessing multiple databases with the code listed
below.
It errors on the 2nd db select statement and says that the table does not
exist.
I am using 2 identical db for the test with different names. Any idea what I
am
doing wrong? - Thanks, Jan Zumwalt
?php
echo
it.
Marc
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of jwzumwalt
Sent: Tuesday, February 28, 2012 5:05 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] accessing multiple databases
I'm attempting to do a test accessing