From https://sqlite.org/cli.html :
"If no database file is specified on the command-line, a temporary database is created, then deleted when the "sqlite3" program exits."
I'll bet that's what you are seeing, only using the ODBC driver rather than the command line: a temporary database created and deleted, like a cursor.
On Thu, Nov 16, 2017 at 9:21 AM, Ted Roche tedroche@gmail.com wrote:
And:
? SQLDisconnect(0) ? SQLStringConnect("Driver={SQLite3 ODBC Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;") ? SQLExec(1,"Select * from Example2") brow norm
disconnects all ODBC connections, reconnects, and shows the two records in the table, so that's working.
On Thu, Nov 16, 2017 at 8:57 AM, Ted Roche tedroche@gmail.com wrote:
On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche tedroche@gmail.com wrote:
On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver paul@tpcqpc.com wrote:
Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have some weird behavior going on.
Having worked with Whil on a half-dozen books now, I have to say, weird behavior is par for the course. ;)
Here's what I did. I called up a DSN I had previously created and like you, copied the ConnectString when it opened. The only big difference I notice is that my string is using "Database" rather than DBNAME.
? SQLStringConnect("Driver={SQLite3 ODBC Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;") ? SQLExec(4, "Create table Example2 (key int, description text)") ? SQLExec(4, "insert into Example2 (key, description) values (1,'The first')") ? SQLExec(4, "insert into Example2 (key, description) values (2,'The second')")
the "newexample.sqlite" database did not exist before I started. It's on disk now, at 8 kb.
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com