SQLiteDatabase.CreateDatabase

From Xojo Documentation

Revision as of 15:42, 12 November 2019 by PLefebvre (talk | contribs) (Notes)
You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!
Method

SQLiteDatabase.CreateDatabase()

Supported for all project types and targets.

Creates a new SQLiteDatabase using the FolderItem in the DatabaseFile property.

Notes

If the database already exists, this function works like Database.Connect. If CreateDatabase succeeds, the DatabaseFile property will bet set to the DatabaseFile. If CreateDatabase does not succeed, an IOException is raised.

This code creates a database file and catches the exception if the operation fails:

Var db As New SQLiteDatabase
db.DatabaseFile = SpecialFolder.Desktop.Child("MyDatabase.sqlite")
Try
db.CreateDatabase
Catch error as IOException
MessageBox("The database file could not be created: " + error.Message)
End Try