Database location for testing Xojo

Getting Started
1

Hi everyone, downloaded Xojo for desktop on linux for testing before buying a build license.
My question is, where/ in which folder do I place my “db.sqlite” so I don’t have to define an absolute path in my application?
The reason is that if I decide to purchase a license to build application I don’t feel like having to change back all the absolut path to a relative path e.g. database will be residing in the same folder as application itself.

2

On many platforms, security will not allow you to place the db file in the same location as the executable. I wouldn’t declare an absolute path, but I’d look into using http://documentation.xojo.com/index.php/SpecialFolder … This will allow you to not hardcode, but know where your file should be and also be cross platform.

3

Thanks I get that.
For testing purposes, since I cannot build yet, I would like to know where the ‘CurrentWorkingDirectory’ is on linux?

4

Since CurrentWorkingDirectory is a method on SpecialFolder, and is a FolderItem type, you can use: http://documentation.xojo.com/index.php/FolderItem.NativePath

In your app, do something like:

System.DebugLog SpecialFolder.CurrentWorkingDirectory.NativePath

// Or

MsgBox SpecialFolder.CurrentWorkingDirectory.NativePath
5

OK thanks again…

6

[quote=88083:@Vic Frank]…
My question is, where/ in which folder do I place my “db.sqlite” so I don’t have to define an absolute path in my application?….[/quote]
SpecialFolder. ApplicationData would be the safest place, unless you have a requirement to access such sqlite database also with other applications. Then it would be SpecialFolder.Documents (sandboxed OSX apps excluded!)

7

Just in case:

you cannot build a stand alone application, but you can run the application in the IDE, isn’t it ?