DuckDB Plugin for Xojo

PreparedStatement.BindCurrency Method

Binds Currency value to the prepared statement.

BindCurrency(
   fieldNumber as Integer,
   value as Currency)

Parameters

fieldNumber
The field number in the prepared statement (zero based).
value
The value to put in the field.

Remarks

Xojo Currency data type is defined as:
A a decimal number that holds 15 digits to the left of the decimal point and 4 digits to the right.

So in the duck DB you would create compatible field like this:
CREATE TABLE decimals(s DECIMAL(15,4))

See Also

PreparedStatement Class