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.