Platforms to show: All Mac Windows Linux Cross-Platform

Back to Database class.

Database.DatabaseName as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The name of the database to open.
Example
dim db as new SQLDatabaseMBS
db.DatabaseName="PostgreSQL:127.0.0.1,5432@dbname=postgres connect_timeout=10 sslmode=require"

The DatabaseName is typically used with server databases (such as MySQL or PostgreSQL) to identify the specific database to use on the server.

Please set the DatabaseName, UserName and Password properties when using SQLDatabaseMBS class. The Host property is ignored.
The database name must contain the complete information and a prefix for the kind of database.
(Read and Write property)

Database.Error as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
True if an error is returned from the database engine.

See the values of the ErrorCode and ErrorMessage properties to learn the specifics of the error.

You should check the Error property after each database operation to see if there was an error. If there is an error, you can display or log the ErrorCode and ErrorMessage.
(Read and Write property)

Database.ErrorCode as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The error code returned from the database.

Error codes and error messages are different for each database.
(Read and Write property)

Database.ErrorMessage as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Text of the error message returned from the database.

Error codes and error messages are different for each database.
You should check the Error property after each database operation to see if there was an error. If there is an error, you can display or log the ErrorCode and ErrorMessage.
(Read and Write property)

Database.Host as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The database host name or IP address of the database server.

(Read and Write property)

Database.Password as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The password that is required for access to the database.

Typically used in conjunction with UserName.
(Read and Write property)

Database.UserName as String

Type Topic Plugin Version macOS Windows Linux iOS Targets
property SQL MBS SQL Plugin 1.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The username that is required for access to the database.

(Read and Write property)

The items on this page are in the following plugins: MBS SQL Plugin.


The biggest plugin in space...