Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Database.DatabaseName as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: The name of the database to open.
Example:
dim db as new SQLDatabaseMBS
db.DatabaseName="PostgreSQL:127.0.0.1,5432@dbname=postgres connection_timeout=10 sslmode=require"
Notes:
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)

Feedback, Comments & Corrections

Database.Error as Boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: True if an error is returned from the database engine.
Notes:
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)

Feedback, Comments & Corrections

Database.ErrorCode as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: The error code returned from the database.
Notes:
Error codes and error messages are different for each database.
(Read and Write property)

Feedback, Comments & Corrections

Database.ErrorMessage as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: Text of the error message returned from the database.
Notes:
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)

Feedback, Comments & Corrections

Database.Host as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: The database host name or IP address of the database server.
Notes: (Read and Write property)

Feedback, Comments & Corrections

Database.Password as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: The password that is required for access to the database.
Notes:
Typically used in conjunction with UserName.
(Read and Write property)

Feedback, Comments & Corrections

Database.UserName as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 1.0 Yes Yes Yes Yes No
Function: The username that is required for access to the database.
Notes: (Read and Write property)

Feedback, Comments & Corrections

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




Links
MBS Xojo Plugins