Nil Object Exception

Databases
1

Dim dbFile As FolderItem dbFile = GetFolderItem("file:///Z:/Documents/Xojo%20Projects/SmartProject/database.sqlite",FolderItem.PathTypeURL) If dbFile.Exists Then App.db.DatabaseFile = dbFile <<---- Nil Object Exception Else MsgBox("The FolderItem does not exist.") End If

Any ideas as to why? The file path is valid.

Edit (Paul): Added Code tags as described in Post Formatting Tips

2

Did you instantiate App.DB somewhere?

App.DB = New SQLiteDatabase
3

Is there supposed to be 3 slashes after file:?

4

Yes, Paul, that was it. I has it set incorrectly.

Garth, 3 slashes is correct for URL path.

5

As an aside, in the future, please use the code tags around code to make it a little easier for us.

6

yes
file uri’s are odd

normally its file://host/path
but when host is “localhost” it can be omitted leading to file:///path

7

Thanks Norman - see, I saw the 3 slashes, and I THOUGHT it was weird, so I researched it, even going to RFC 1738 (“A file URL takes the form: file:///”) before I answered. Thanks for taking the extra step for me.

8

yer covfefe !

I think thats the right usage
Unless of course its a swear but then who knows :slight_smile: