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:

• /DynaPDF/DynaPDF Database Invoice Example
• /DynaPDF/DynaPDF Graphics/Reporting/GasReport/GasReport
• /MacControls/Listbox and TableView Demos/ListboxTV drop-in/Flat Only/ListBoxTV Database with DataSource
• /SQL/PostgreSQL API
• /SQL/SQLDatabaseMBS Microsoft SQL Connect
• /SQL/SQLDatabaseMBS Oracle Connect
• /SQL/SQLDatabaseMBS SQLite load extension
• /SQL/SQLite Backup
• /SQL/SQLite Connect
• /SQL/SQLite Connect in Memory Database

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

DASessionMBS   -   DatagramMBS