Switch to: V10V9V8V7V6V5

Properties of Database Class

This page contains properties that VSqliteDatabase class inherits from Database class of Xojo.

VSqliteDatabase.DatabaseName

Declaration:

DatabaseName as String

Description:

The DatabaseName is used with Valentina Sqlite Server to identify the specific database to use on the server.

This property is not used when you work with LOCAL Sqlite database. It uses DatabaseFile instead.

(!) Xojo expects that you specify DatabaseName only before connect(). We have eased this requirement. You can skip databaseName before connect(), in this case connect() just establishes connection to remote Server. After this you can specify databaseName and execute CreateDatabaseFileEx(), OpenDatabaseFile()

Example:

// This example assumes that database exists on the server:
dim db as New VSqliteDatbase
 
db.Host = "127.0.0.1"
db.UserName = "sa"
db.Password = "sa"
db.DatabaseName = "mydb.db"
 
If db.Connect() Then
  // Use the database
Else
  // DB Connection error
  MsgBox(db.ErrorMessage)
End If

Others

Other properties of Database class works in 100% the same way, so we provide direct links to Xojo Docs about these properties: