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

[<bugtracker@xxxxxxxxxxxxxx>]

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

Comment #10 by Claus DIETRICH:

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

I expected something like this because the returned URL in the connection-class looks "special". 

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

I can imagine the use of read-only-databases (delivered with the app) and why shouldn't it be possible to open them for reading while they reside in the project root path?

Best regards
Claus


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