Good morning all,
Is there an odbc driver for Sqlite3?
It would be useful to be able to use existing data tools...
=
-
The Castles of Dereth Calendar: a tour of that art and architecture of the
online game world of Asheron's Call
http://www.lulu.com/content/
Hi all,
How can I import NULL values using the new .import function?
The old \N of the COPY statement does not work.
How can I escape the separator in the import file?
Suppose I want to use ; as a separator then \; does not work.
Thanks and regards,
T. Rausch
__
amead writes:
> It's a bit of a long-shot, but have you tried the 'cygdrive' path syntax?
>
> $ sqite /cygdrive/c/cygwn/usr/local/share/refdb/db/refdb
>
> (assuming you installed Cygwin on C:\cygwin)
>
Actually I did not try this yet. I'll do so tomorrow, as I don't have
any windoze stuff
Markus Hoenicka wrote:
Hi,
I've just built 2.8.15 on Cygwin which worked without a hitch (thanks to those
who added Cygwin support in the past). However, I came across a problem that
makes working with databases a bit inconvenient. It seems like the library does
not understand absolute paths, only
For MacOS X 10.3 users;
I was going to start to using sqlite in a project, but I need first to
create a skeleton of a browser to add some of my data.
If someone wants to use it (disclaimer: version 0.1 software), it's
here:
http://homepage.mac.com/fernandoluis/.cv/fernandoluis/Public/
SquidS
These are various issues I had and some suggestions based on
writing a Python wrapper for SQLite 3. Overall I was very
impressed by the quality of the doc, and of course SQLite 3
itself. Overall the wrapper ended up being just under 3,000
lines of code and provides all the functionality of the C
APSW (Another Python SQLite Wrapper) 3.0.8-r2 is now available. Download from
http://sourceforge.net/project/showfiles.php?group_id=75211&package_id=113804
Documentation is included in the download and is online at
http://www.rogerbinns.com/apsw.html
There is an example at the top of the documen
Good day,
I've written a SQLite version 3 interface for CMUCL,
which can be found here:
http://www.randallsquared.com/download/sqlite/cmucl-sqlite3/
with documentation at:
http://www.randallsquared.com/cs-doc.shtml .
It automatically caches prepared statements, supports
the binding API, and is publ
-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 se
Yes but then I must repeat the column names in every query in which I use the
view. It is a bug in SQLite, isn't it?
Jakub
Brass Tilde ([EMAIL PROTECTED]) wrote*:
>
> > create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a;
> > create table problem as select * from myview;
>
> Ch
Hi,
sorry for the noise. Switching off large file support works as advertized.
However, "make clean" is not clean enough to remove the previous configuration.
Large file support is off if I start from scratch using the compiler switch
suggested in os.h.
Now I bump into the locking issue that we'v
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 won'
Hi,
in an attempt to investigate the absolute vs. relative path problem on Cygwin
I've played with a few build possibilities. Interestingly, sqlite now builds
Unix-style on Cygwin, something that failed in the past. This requires the
following definition in Makefile:
TCC = gcc -g -O2 -DOS_UNIX=1
On Mon, Dec 13, 2004 at 02:00:05PM -, Richard Boyd wrote:
> My question is this: Is it possible for me to copy across the database file
> and then append it to the end of the locally held database thus
> synchronizing the two? Is there a better way to do this synchronization?
If both database
Hi all,
I have an application where I need to access a database remotely (using
TCP/IP). I had thought of just calling sqlite commands (possibly using RPC)
and getting database data returned. However, as I will only periodically
access the remote database, I need to effectively keep a copy of the
> create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a;
> create table problem as select * from myview;
Change this last line to:
create table problem as select a as a from myview;
That creates the problem table with just "a" as the field name.
Hi all, I have a nasty problem with VIEWs and column names. I create a
VIEW by joining two tables. If I use this view to create the table
'problem', the column name "t1.a" appears instead of the expected (and
needed) "a".
Is it a bug? Do you have an idea how to use the view so as it works?
Than
17 matches
Mail list logo