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 relative paths. You can simply test this
with the command line tool sqlite:

[EMAIL PROTECTED] ~/lit
$ sqlite /usr/local/share/refdb/db/refdb
SQLite version 2.8.15
Enter ".help" for instructions
sqlite> select * from CITSTYLE;
Unable to open database "/usr/local/share/refdb/db/refdb": unable to open databa
se: /usr/local/share/refdb/db/refdb
[EMAIL PROTECTED] ~/lit
cd /
[EMAIL PROTECTED] /
$ sqlite usr/local/share/refdb/db/refdb
SQLite version 2.8.15
Enter ".help" for instructions
sqlite> select * from CITSTYLE;
[lots of entries]
cd -
[EMAIL PROTECTED] ~/lit
$ sqlite  ../../../usr/local/share/refdb/db/refdb
SQLite version 2.8.15
Enter ".help" for instructions
sqlite> select * from CITSTYLE;
[lots of entries]

The same problem occurs if I use an application linked against libsqlite. If I
set the absolute path to the database file, the app fails. If I start the app
in / and pass the relative path, the app works ok.

I'm currently away from my Linux/BSD boxes, so I can't tell whether this problem
is specific to Cygwin. Can anyone help?

regards,
Markus



-- 
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Reply via email to