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

[<bugtracker@xxxxxxxxxxxxxx>]

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

Comment #18 by Claus DIETRICH:

Hi Benoît 

>In other words, there is no way for sqlite to be able to see a sqlite database file located inside a project, except at design time.

Why then is it possible to read the database during runtime with the demo app 
a) by just adding a mysterious "/." at the end of the absolute path if the data base is located in the project root directory?
b) by the normal absolute path if it is located in a subdirectory of the project root directory? 

Demo-app download: https://magentacloud.de/s/7jbZD5Ywks5FNZB

>The user opening the database in read-only mode is not a guarantee that sqlite will not write in the file. You can't know.

How can this be if the file is read-only? I am assuming that any attempt to write into such database would lead to an error, which would be OK.

I found in a another forum, that a sqlite database connection can be opened in read-only mode:
https://forum.xojo.com/t/read-only-sqlite-db-in-resource-folder/46200/11
which doesn't seem to be supported by Gambas.

With best regards
Claus


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