Platforms to show: All Mac Windows Linux Cross-Platform
Database class
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | SQL | MBS SQL Plugin | 1.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Use one of the subclasses to connect to your database.
- 7 properties
- property DatabaseName as String
- property Error as Boolean
- property ErrorCode as Integer
- property ErrorMessage as String
- property Host as String
- property Password as String
- property UserName as String
- 17 methods
- method AddRow(TableName as String, row as DatabaseRow)
- method BeginTransaction
- method Close
- method Commit
- method CommitTransaction
- method Connect
- method Connect as boolean
- method ExecuteSQL(sql As String, ParamArray values As Variant)
- method ExecuteSQL(sql As String, values() As Variant)
- method InsertRecord(TableName as String, Data as DatabaseRecord)
- method Prepare(statement as String) as PreparedSQLStatement
- method Rollback
- method RollbackTransaction
- method SelectSQL(sql As String, ParamArray values As Variant) as RowSet
- method SelectSQL(sql As String, values() As Variant) as RowSet
- method SQLExecute(ExecuteString as string)
- method SQLSelect(SelectString as string) as RecordSet
Sub classes:
Some examples using this class:
- /DynaPDF/DynaPDF Database Invoice Example
- /DynaPDF/DynaPDF Graphics/Reporting/GasReport/GasReport
- /Java/JavaDatabase/JavaDatabase MySQL test 2
- /SQL/Oracle Connect
- /SQL/SQLDatabaseMBS Microsoft Access Connect
- /SQL/SQLDatabaseMBS MySQL Fetch values
- /SQL/SQLDatabaseMBS SQLite load extension
- /SQL/SQLite Backup
- /SQL/SQLite Connect
- /SQL/SQLite Display Schema
The items on this page are in the following plugins: MBS SQL Plugin.

Links
MBS Xojo Chart Plugins