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
• /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.

DASessionMBS   -   DatagramMBS