[Gambas-bugtracker] Bug #2986: sqlite connection "Database does not exist"

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.2986&from=L21haW4-

Comment #9 by Benoît MINISINI:

The problem comes from an incoherency between the sqlite3 driver and the IDE.

The IDE transforms a database path located inside a project into a path relative to the project, and a null 'Host' Connection property.

But when the sqlite3 driver sees a relative path and a null 'Host' property, it assumes that the path is relative to the home directory.

As I said before, databases located in the project are a no-go. They are as if they do not exist.

What I could suggest is that at runtime, when a relative path with a null host is seen, the sqlite3 will search the database file inside the project executable, and then make a copy into a temporary file so that the database can be opened.

Benoît MINISINI changed the state of the bug to: Accepted.


----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----