Author: Ted Roche
Posted: 2017-11-16 at 08:21:12
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
--
Ted Roche
Ted Roche & Associates, LLC
_______________________________________________
Post Messages to: ProFox@leafe.com
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/CACW6n4smOyLqNoqhkrbFr=RmFUk7gOOAO87fV2rmCNUxnNKuPQ@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.