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 SQLite 2.8.15.
If the Delphi interface handles quoted strings in the CSV data then you can
quote the columns that may contain commas. Use something like this:
SELECT lastname, '"' || bussiness || '"' FROM customers ...
The || operator is the concatenation operator. This adds double quotes
around all the bussiness name strings.
Right. Unfortunately, the SQLite header uses regular expressions to
split the results. However, I can probably muck around in the header
file and make that work... The obvious problem with that I have to
update all my SQL queries...
Temporary tables are destroyed when the database connection is closed or
when the user explicitly drops them.
"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?
I hope this helps.
Thanks for the suggestions!
--
Taj
