On Sep 1, 2006, at 5:32 AM, Simen Haugen wrote:

By just setting the current working directory to the applications
directory this is fixed. This is not a dabo issue after all, but just
the way sqlite works. My fault for not checking how sqlite works.

To be fair, it's also the fault of Dabo for its weak handling of pathing. I have a few ideas that I haven't had time to test, but I'd like to be able to store all paths as relative paths in a platform- neutral way, and then at run time, be able to reconstruct the path for that platform.

For example, let's say I'm working on Windows, and my app is located in D:\MyApp, and my SQLite database is in a subdirectory of that named 'data'. That path gets stored as 'D:\MyApp\data\my.db', when all I really care about is that it is that the name is 'my.db' and that it's located in a subdirectory immediately off of the main one named 'data'. If I then run that app on Linux from a directory named / home/ed/projects/foo, with the data in /home/ed/projects/foo/data, that absolute Windows path will mean nothing, but if had stored a relative path, it would work.

-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com




_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Reply via email to