Platforms to show: All Mac Windows Linux Cross-Platform
DuckPreparedStatementMBS.BindBlob(index as Integer, value as MemoryBlock)
Function:
Binds a value to a BLOB field.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
See also:
DuckPreparedStatementMBS.BindBlob(index as Integer, value as String)
Function:
Binds a value to a BLOB field.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
See also:
DuckPreparedStatementMBS.BindBoolean(index as Integer, value as Boolean)
Function:
Binds boolean value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindDouble(index as Integer, value as Double)
Function:
Binds double value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindFloat(index as Integer, value as Single)
Function:
Binds single value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindInt16(index as Integer, value as Int16)
Function:
Binds Int16 value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindInt32(index as Integer, value as Int32)
Function:
Binds Int32 value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
Some examples using this method:
DuckPreparedStatementMBS.BindInt64(index as Integer, value as Int64)
Function:
Binds Int64 value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindInt8(index as Integer, value as Int8)
Function:
Binds Int8 value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindNull(index as Integer)
Function:
Binds NULL value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindString(index as Integer, value as String)
Function:
Binds String value to given parameter.
Notes: Index is one based.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes: Index is one based.
DuckPreparedStatementMBS.BindValue(index as Integer, value as Variant)
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.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
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)
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.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Notes:
Please make sure that ubound and parameter count matches.
If value is a Memoryblock, we bind as BLOB.
DuckPreparedStatementMBS.Constructor private
Function:
The private constructor.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
DuckPreparedStatementMBS.Destructor
Function:
The destructor.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
DuckPreparedStatementMBS.SQLExecute as Boolean
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.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
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
Function:
Executes the prepared statements with currently bound parameters.
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 |
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.