[sqlite] ODBC driver?

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

[sqlite] .import function - NULL values

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

Re: [sqlite] absolute vs. relative path to database on Cygwin

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

Re: [sqlite] absolute vs. relative path to database on Cygwin

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

[sqlite] Feedback from a wrapper writer

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

[sqlite] ANN: APSW (Another Python SQLite Wrapper) 3.0.8-r2

APSW (Another Python SQLite Wrapper) 3.0.8-r2 is now available. Download from http://sourceforge.net/project/showfiles.php?group_id=75211_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 documentation

[sqlite] ANN: cmucl-sqlite3 (Common Lisp SQLite3 interface)

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

Re: [sqlite] commas in columns and temporary tables

-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

Re: [sqlite] coding style

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; > >

Re: [sqlite] switching off large file support?

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

Re: [sqlite] commas in columns and temporary tables

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

[sqlite] switching off large file support?

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

[sqlite] synchronising two databases

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

Re: [sqlite] coding style

> 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.

Re: [sqlite] coding style

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?