Platforms to show: All Mac Windows Linux Cross-Platform

DuckConnectionMBS.BeginTransaction as Boolean
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
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.
DuckConnectionMBS.Commit as Boolean
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
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.
DuckConnectionMBS.Constructor
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: The constructor.
Example: 
dim d as new DuckConnectionMBS
Notes: Creates a new in-memory database and connects to it.
DuckConnectionMBS.Destructor
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: The destructor.
Notes: Closes connection.
DuckConnectionMBS.Prepare(SQL as String) as DuckPreparedStatementMBS
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Prepares the specified SQL query in the specified connection handle.
DuckConnectionMBS.Rollback as Boolean
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
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.
DuckConnectionMBS.SQLExecute(SQL as String) as Boolean
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Executes the specified SQL query in the specified connection handle.
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
Notes:
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
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Executes the specified SQL query in the specified connection handle.
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);")
Notes: ErrorMessage property is set in case of error.

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

Feedback: Report problem or ask question.

The biggest plugin in space...