open a database in an application

Databases
1

I have built the url tracker emo app and it works. now I am trying to learn how to store the data in a database. I have created a database named urldb. it contains three fields in it: url, comment, changedate. I have inserted the database in my project but when I try to run it I get the following error message:
The ‘app’ has no member named ‘urldb’
app.urldb.databasefile = dbfile

I have set the above value thusly:
// The DB file will be on the desktop
Dim dbFile As FolderItem = SpecialFolder.Desktop.Child(“urldb.sqlite”)
can someone tel me what I am doing wrong?

2

Try this:

urldb.databasefile = dbfile
3

You may want to start from here:
http://documentation.xojo.com/index.php/SQLiteDatabase#Examples

4

Thank you the examples help a lot. I was trying to copy and past code from an existing sample program and may have omitted something. is here anyway to search the entire project for a specific item?

5

the find field in the top left corner of your project …
or the find panel at the bottom
http://developer.xojo.com/userguide/find-errors-messages-panels