Joe Wilson wrote:
>
> Hi Christian,
>
> I'm not sure what this patch to SQLite 3.3.12 does.
> Is it fixing a bug or extending SQLite for use in your ODBC driver?
> Should a ticket be created for it in SQLite CVSTrac?
I've already created a low priority ticket for it, see
Hi Christian,
I'm not sure what this patch to SQLite 3.3.12 does.
Is it fixing a bug or extending SQLite for use in your ODBC driver?
Should a ticket be created for it in SQLite CVSTrac?
thanks.
# patch: parse foreign key constraints on virtual tables
patch -d sqlite3 -p1 <<'EOD'
diff -ur
Joe Wilson wrote:
> Nice job on the new driver.
>
> The new DSN parameter LoadExt=module1.dll,module2.dll for dynamically
> loadable sqlite extension modules is particularly useful.
>
> The SQLite+TCC extension is very cool.
Thank you, Joe!
If only I had added that patch to sqlite+tcc.c
--- David M X Green <[EMAIL PROTECTED]> wrote:
> I'm trying sqlite3 run on WinXP by console using
> (1) cygwin bash &
> (2) bash run on rxvt.
> I find sqlite3 - interactive does not work well with .help.
> With just bash only part of the help printed to the screen; though the second
> attempt
On Sat, 10 Feb 2007, Kees Nuyt wrote:
This is not a comma delimited values file like .import could
process, but an SQL script. You can execute it like:
sqlite3 databasefilename .read variable.sql
Kees,
Thank you. I knew it was somthing simple.
Rich
--
Richard B. Shepard, Ph.D.
On Sat, 10 Feb 2007 12:09:12 -0800 (PST), you wrote:
>On Thu, 28 Sep 2006, Dennis Cote wrote:
>
>> I suspect you may have trailing spaces at the ends of your lines. The
>> .import command isn't very smart about things like that. Your separator is
>> set to one space, not arbitrary whitespace. It
I'm trying sqlite3 run on WinXP by console using
(1) cygwin bash &
(2) bash run on rxvt.
I find sqlite3 - interactive does not work well with .help.
With just bash only part of the help printed to the screen; though the second
attempt seemed to provide the complete listing.
With rxvt-bash
On Thu, 28 Sep 2006, Dennis Cote wrote:
I suspect you may have trailing spaces at the ends of your lines. The
.import command isn't very smart about things like that. Your separator is
set to one space, not arbitrary whitespace. It there is another separator
after the last field it assumes
On 2/10/07, T <[EMAIL PROTECTED]> wrote:
Hi all,
I have some imported data, where some fields contain numbers with
commas denoting thousands separators. How can I change these to
actual numbers?
If you're using unix or linux there are very nice tools for cleaning up the
data before loading
On 2/10/07, Brodie Thiesfield <[EMAIL PROTECTED]> wrote:
Hi,
I'm looking for some SQL advice. I have a query which is used as the
base of a filter. At the moment I am using:
SELECT * FROM table WHERE (1=? OR foo=?);
The actual query is more complex and uses multiple of the constructions
in
Hi,
I'm looking for some SQL advice. I have a query which is used as the
base of a filter. At the moment I am using:
SELECT * FROM table WHERE (1=? OR foo=?);
The actual query is more complex and uses multiple of the constructions
in this WHERE clause. If I wanted to select on the foo column
Nice job on the new driver.
The new DSN parameter LoadExt=module1.dll,module2.dll for dynamically
loadable sqlite extension modules is particularly useful.
The SQLite+TCC extension is very cool.
Thanks.
--- Christian Werner <[EMAIL PROTECTED]> wrote:
> Version 0.72 of the SQLiteODBC Driver is
T wrote:
I have some imported data, where some fields contain numbers with
commas denoting thousands separators. How can I change these to
actual numbers?
I tried using CAST, which only works with later SQLite versions, but
it doesn't seen to know the comma as the thousands marker. For
T wrote:
Hi all,
I have some imported data, where some fields contain numbers with
commas denoting thousands separators. How can I change these to actual
numbers?
I tried using CAST, which only works with later SQLite versions, but it
doesn't seen to know the comma as the thousands
Hi all,
I have some imported data, where some fields contain numbers with
commas denoting thousands separators. How can I change these to
actual numbers?
I tried using CAST, which only works with later SQLite versions, but
it doesn't seen to know the comma as the thousands marker. For
Version 0.72 of the SQLiteODBC Driver is ready for
download from http://www.ch-werner.de/sqliteodbc
It now supports loadable extensions as of SQLite >= 3.3.7
in the form of a DSN option.
The one-click Win32 installer is based on SQLite 3.3.12
and contains the FTS1/FTS2 extensions and the
16 matches
Mail list logo