Platforms to show: All Mac Windows Linux Cross-Platform

DuckPreparedStatementMBS.BindBlob(index as Integer, value as MemoryBlock)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds a value to a BLOB field.
Notes: Index is one based.

See also:

DuckPreparedStatementMBS.BindBlob(index as Integer, value as String)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds a value to a BLOB field.
Notes: Index is one based.

See also:

DuckPreparedStatementMBS.BindBoolean(index as Integer, value as Boolean)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds boolean value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindDouble(index as Integer, value as Double)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds double value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindFloat(index as Integer, value as Single)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds single value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindInt16(index as Integer, value as Int16)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds Int16 value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindInt32(index as Integer, value as Int32)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds Int32 value to given parameter.
Notes: Index is one based.

Some examples using this method:

DuckPreparedStatementMBS.BindInt64(index as Integer, value as Int64)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds Int64 value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindInt8(index as Integer, value as Int8)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds Int8 value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindNull(index as Integer)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds NULL value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindString(index as Integer, value as String)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds String value to given parameter.
Notes: Index is one based.
DuckPreparedStatementMBS.BindValue(index as Integer, value as Variant)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds variant value to given parameter.
Notes:
Depending on variant type, invokes bind for Null, string, integer, Int64, double, single or boolean.
Index is one based.
If value is a Memoryblock, we bind as BLOB.
DuckPreparedStatementMBS.BindValues(values() as Variant)
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: Binds all values with the given array.
Notes:
Please make sure that ubound and parameter count matches.
If value is a Memoryblock, we bind as BLOB.
DuckPreparedStatementMBS.Constructor private
Type Topic Plugin Version macOS Windows Linux iOS Targets
method DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: The private constructor.
DuckPreparedStatementMBS.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.
DuckPreparedStatementMBS.SQLExecute 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 prepared statements with currently bound parameters.
Notes:
No result is provided, but true on success and false on failure.
ErrorMessage property is set in case of error.
DuckPreparedStatementMBS.SQLSelect 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 prepared statements with currently bound parameters.
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...