SQLite in ApplicationData Mac OS

Hi, please I need help.
I want the SQLite database is installed in the folder where the database applications are stored on MAC OS.
For this I use the following statement:
dim f as folderitem
f = SpecialFolder.ApplicationData.Child(“Cordina.rdb”)
The problem If I go to see if the database was created in my Mac (Library/Application Support), the database was not created.
You would be so kind as to tell me what I’m missing?
Thanks very much for any help.

You can try doing something like this:

Dim f as Folderitem
f = SpecialFolder.ApplicationData.Child(“Cordina.rdb”)
Dim db As New SQLiteDatabase
db.DatabaseFile = f
If db.CreateDatabaseFile Then
// proceed with database operations
Else
MsgBox "Database not created. Error: " + db.ErrorMessage
End If

If the database file is not created, you will get a message. It tells why it has not been created.

Hi Payam and thanks very much for your help.
I have tried your exemple, I have put a button and paste your code, problem Is If I go to, Library/Application Support, I d’ont can see the sqlite database ‘Cordina.rdb’.

I d’ont have any message or warning.

Hi Payam, my problem was resolved.
Thanks very much for spend time to help me, have a nice day.

[quote=127521:@Juan Duran]Hi Payam, my problem was resolved.
Thanks very much for spend time to help me, have a nice day.[/quote]

what resolved your issue?

Hi Scott, yes my answer are resolved, my problem was In my mac my files are hidden and I had to use the terminal to see the file created in the library-application support, and all is now well, I can see the created sqlite database.
Thanks very much for your interest and have a nice day.