DuckDB Plugin for Xojo

Appender.AppendCurrency Method

Adds Currency field to the row.

AppendCurrency(
   value as Currency)

Parameters

value
The value to be added.

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

Appender Class