Re: [sqlite] commas in columns and temporary tables

[Dennis Cote]

Taj Morton wrote:
> Dennis,
>
> Indeed. Actually, I'm using an OO wrapper around that library,
> TSQLiteDB
> (http://homepages.borland.com/torry/db/direct/db_directsql/tsqlite.zip).

This link gives me a 404 error so I can't look at the code myself.

>
> Here's my TEMPORARY TABLE code:
> // DB is a TSQLiteDB created on FomCreate
> DB.SQL:='CREATE TEMPORARY TABLE cname2cid(cid INTEGER,name
> VARCHAR(512));'; DB.ExecSQL;
>
> DB.SQL:='SELECT id,firstname,lastname,business from customers;';
> DB.Open;
> //...
> DB.Close;

What do DB.Open and DB.Close do? I think maybe they should surround the
other code as well, like this:

  // DB is a TSQLiteDB created on FomCreate
  DB.Open;
  DB.SQL:='CREATE TEMPORARY TABLE cname2cid(cid INTEGER,name
VARCHAR(512));';
  DB.ExecSQL;

  DB.SQL:='SELECT id,firstname,lastname,business from customers;';
  //...
  DB.Close;

Let me know if this works.