Platforms to show: All Mac Windows Linux Cross-Platform
DuckConnectionMBS.BeginTransaction as Boolean
Function:
Starts a transaction.
Notes:
Returns true on success and false on failure.
Calls SQLExecute internally, but more efficiently.
ErrorMessage property is set in case of error.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns true on success and false on failure.
Calls SQLExecute internally, but more efficiently.
ErrorMessage property is set in case of error.
DuckConnectionMBS.Commit as Boolean
Function:
Commits current transaction.
Notes:
Returns true on success and false on failure.
Calls SQLExecute internally, but more efficiently.
ErrorMessage property is set in case of error.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns true on success and false on failure.
Calls SQLExecute internally, but more efficiently.
ErrorMessage property is set in case of error.
DuckConnectionMBS.Constructor
Function:
The constructor.
Example:
Notes:
Creates a new in-memory database and connects to it.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Example:
dim d as new DuckConnectionMBS
DuckConnectionMBS.Destructor
Function:
The destructor.
Notes: Closes connection.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Closes connection.
DuckConnectionMBS.Prepare(SQL as String) as DuckPreparedStatementMBS
Function:
Prepares the specified SQL query in the specified connection handle.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
DuckConnectionMBS.Rollback as Boolean
Function:
Rolls back current transaction.
Notes:
Returns true on success and false on failure.
Calls SQLExecute internally, but more efficiently.
ErrorMessage property is set in case of error.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Returns true on success and false on failure.
Calls SQLExecute internally, but more efficiently.
ErrorMessage property is set in case of error.
DuckConnectionMBS.SQLExecute(SQL as String) as Boolean
Function:
Executes the specified SQL query in the specified connection handle.
Example:
Notes:
No result is provided, but true on success and false on failure.
ErrorMessage property is set in case of error.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Example:
Dim con As New DuckConnectionMBS // new in memory database
// create a table
Call con.SQLExecute("CREATE TABLE integers(i INTEGER, j INTEGER);")
// insert three rows into the table
Call con.SQLExecute("INSERT INTO integers VALUES (3, 4), (5, 6), (7, NULL);")
Dim result As DuckResultMBS = con.SQLSelect("SELECT * FROM integers")
Break // inspect in debugger
No result is provided, but true on success and false on failure.
ErrorMessage property is set in case of error.
DuckConnectionMBS.SQLSelect(SQL as String) as DuckResultMBS
Function:
Executes the specified SQL query in the specified connection handle.
Example:
Notes:
ErrorMessage property is set in case of error.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Example:
// no path, so in memory
Dim db As New DuckDatabaseMBS
Dim con As DuckConnectionMBS = db.Connect
// create a table
Call con.SQLSelect("CREATE TABLE integers(i INTEGER, j INTEGER);")
The items on this page are in the following plugins: MBS DuckDB Plugin.
Feedback: Report problem or ask question.