>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 <[email protected]> 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 <[email protected]> wrote: >> On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche <[email protected]> wrote: >>> On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <[email protected]> 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 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tx1+yn7iv32ayhun08c5mhkmgh3+fusj-kdvnlrju...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
