Platforms to show: All Mac Windows Linux Cross-Platform

Database class

• 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:

• class SQLDatabaseMBS

Some examples using this class:

• /GraphicsMagick/GraphicsMagick/Console Text Drawing/Draw text in Console
• /SQL/MySQL Connect
• /SQL/MySQL ExecuteSQL
• /SQL/SQLDatabaseMBS Microsoft SQL Stored Procedure
• /SQL/SQLDatabaseMBS Oracle Connect
• /SQL/SQLDatabaseMBS SQLite Fetch values threaded
• /SQL/SQLDatabaseMBS SQLite select version
• /SQL/SQLite ExecuteSQL
• /SQL/SQLite Fetch values
• /Util/RecordSet to JSON

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

DASessionMBS   -   DatagramMBS