SQLDatabaseMBS.BeginTransaction

This method does nothing. Why?
Well, if auto commit is on, you don't need to call this.
If auto commit is off, we call BeginTransaction for you, so if you call this method you would call it a second time and get an error.
We have this method for compatibility to other SQL database classes from Xojo.

SQLDatabaseMBS.InsertRecord(TableName as String, Record as Dictionary)

Var db as SQLDatabaseMBS // your database connection

Var d as new Dictionary

d.Value("ID")=2
d.Value("text")="test insert"
d.Value("other")="Just a test"

db.InsertRecord("test_tbl", d)

if db.Error then
  MsgBox db.ErrorMessage
end if

The plugin builds for you SQL statement with prepared statement and runs the insert command with values.
Lasterror is set or exception raised as with SQLExecute.
Internally this uses a prepared statement. You can check the generated statement via LastStatement property.

SQLDatabaseMBS.Listen

Works only for PostgresSQL Client.
Please set client or connect before calling this method.

SQLDatabaseMBS.MySQLInsertID as Int64

Please query value right after doing Insert. This value is reset when you call commit.
For mySQL and MariaDB connections.

see also
http://dev.mysql.com/doc/refman/5.1/en/mysql-insert-id.html

SQLDatabaseMBS.Option(name as string) as string

Var c as SQLDatabaseMBS // your database connection

// for Microsoft SQL use OLEDB, so you don't need native SQL drivers installed...
c.Option("UseAPI") = "OLEDB"
c.Option("SQLNCLI.LIBS") = "sqlsrv32.dll" // Library included in Windows Vista and newer

// for SQLite, set flag to open database file read only:
c.Option("SQLiteVFSFlags") = "1"

// turn on auto cache
c.Option("AutoCache") = "true"

// set connection timeout for ODBC:
c.Option("SQL_ATTR_CONNECTION_TIMEOUT") = "10"

// cache insert statements for AddRow/InsertRecord
c.Option("CacheInsertStatement") = "true"

We have a collection of library files here:
https://www.monkeybreadsoftware.de/xojo/download/plugin/Libs/
(Read and Write computed property)

SQLDatabaseMBS.Prepare(statement as string) as SQLPreparedStatementMBS

Returns prepared statement or nil in case of error.
Please check ErrorMessage property for errors.

SQLDatabaseMBS.UpdateRecord(TableName as String, Record as Dictionary, Keys as Dictionary)

Var db as SQLDatabaseMBS // your database connection

Var d as new Dictionary

d.Value("text")="new text"
d.Value("other")="second value"

db.UpdateRecord("test_tbl", d, new dictionary("ID":2))

if db.Error then
  MsgBox db.ErrorMessage
end if

The plugin builds for you SQL statement with prepared statement and runs the update command with given values for records with given key values.

You can put multiple field names in the keys dictionary.

Lasterror is set or exception raised as with SQLExecute.
Internally this uses a prepared statement. You can check the generated statement via LastStatement property.