-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Dennis,
|
| It won't because the temp tables created by your program ar private to its
| database connection. They are not visible through the database connection
| opened by sqlite.exe. You can verify this by running two copies of
| sqlite.exe in
Taj Morton wrote:
> http://www.torry.net/db/direct/db_directsql/sqlitedb.zip should work.
> Sorry about that.
>
I will check this out.
> No go :(. I used breakpoints and checked right after the first
> DB.ExecSQL, then looked at .tables from sqlite.exe...it didn't show up
> their either.
It
Dennis Cote wrote:
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.
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
Dennis,
From your description it sounds like you are using the Delphi wrapper listed
in the wiki as:
Delphi class for SQLite.
http://www.torry.net/db/direct/db_directsql/tsqlite.zip
Indeed. Actually, I'm using an OO wrapper around that library, TSQLiteDB
Taj Morton wrote:
> Dennis Cote wrote:
>
>> Taj,
>>
>> I'm not sure what wrapper you are using, but the sqlite.dll provided
>> by SQLite has two API functions that are used to open and close the
>> database connection. You use sqlite3_open() to open the connection,
>> and sqlite3_close() to close
Dennis Cote wrote:
Taj,
I'm not sure what wrapper you are using, but the sqlite.dll provided by
SQLite has two API functions that are used to open and close the database
connection. You use sqlite3_open() to open the connection, and
sqlite3_close() to close it. Between these two calls you can
Taj Morton wrote:
> "The database connection is closed"...means...? If I'm using the
> SQLite DLL, when is a connection closed? Is it started when I call
> Open, and closed when I call Close (that would mean that a connection
> only lasts for one query)... Can you please explain?
>
Taj,
I'm not
Hi Ulrik,
Now, that's all fine and everything for interactive SQL, but when I'm
using this in a program (written in Delphi), the comma messes up the
returned values (since they are comma seperated)
You can do escaping that replaces the comma with something else when
writing to the table, then
Dennis Cote wrote:
Taj Morton wrote:
Now, I've got two questions.
The first is that I have a column (company) in a customers table. The
problem is that this column has a comma in it for some rows.
That's no good :(. Does anyone have any suggestions on what to do
about this problem? I'm using
Taj,
> Now, I've got two questions.
> The first is that I have a column (company) in a customers table. The
> problem is that this column has a comma in it for some rows. For example:
>
> sqlite> select lastname,business FROM customers WHERE id=449;
> Toleser|St Lawrence University, Biology Dept.
Hi All,
First off, I've been using SQLite in an open-source POS (inventory)
program and am quite happy with it. Thank you all developers and patch
submitters!
Now, I've got two questions.
The first is that I have a column (company) in a customers table. The
problem is that this column has a
12 matches
Mail list logo
