DuckDB Plugin for Xojo

EinhugurDuckDB.Recordset Class

A Recordset provides a way to access a group of Database records (or rows) from a query.

Use methods on the Connection class or the PreparedStatement class to create instances of the Recordset class.

Object
   Recordset

class EinhugurDuckDB.Recordset

Constructors

RecordsetPrivate constructor.

Properties

ColumnCountReturns number of columns in the recordset.
RowCountReturn number of rows in the recordset.

Methods

BlobValueReads Blob value from the recordset by index.
BlobValueReads Blob value from the recordset by named column.
BooleanValueReads Boolean value from the recordset by index.
BooleanValueReads Boolean value from the recordset by named column.
ColumnNameReads column name by index.
CurrencyValueReads Currency value from the recordset by index.
CurrencyValueReads Currency value from the recordset by named column.
DateValueReads Date value from the recordset by index.
DateValueReads Date value from the recordset by named column.
DoubleValueReads Double value from the recordset by index.
DoubleValueReads Double value from the recordset by named column.
Int16ValueReads Int16 value from the recordset by index.
Int16ValueReads Int16 value from the recordset by named column.
Int32ValueReads Int32 value from the recordset by index.
Int32ValueReads Int32 value from the recordset by named column.
Int64ValueReads Int64 value from the recordset by index.
Int64ValueReads Int64 value from the recordset by named column.
Int8ValueReads Int8 value from the recordset by index.
Int8ValueReads Int8 value from the recordset by named column.
IsNullChecks if a field by index in the recordset contains null.
IsNullChecks if a field by name in the recordset contains null.
LogicalTypeReturns enum value representing logical type from the database perspective of a given column.
NextRecordsetReturns instance of next recordset if the query returned more than one recordset, else nil.
SingleValueReads Single value from the recordset by index.
SingleValueReads Single value from the recordset by named column.
StringValueReads String value from the recordset by index.
StringValueReads String value from the recordset by named column.
TimeValueReads Time value from the recordset by index.
TimeValueReads Time value from the recordset by named column.
TimestampValueReads Timestamp value from the recordset by index.
TimestampValueReads Timestamp value from the recordset by named column.

Enumerations

LogicalTypeValuesA enum representing logical data types in a DuckDB database.

Supported Platforms:

  • macOS Intel 32 bit
  • macOS Intel 64 bit
  • macOS Apple Silicon
  • Windows 32 bit
  • Windows 64 bit
  • Windows ARM 64 bit
  • Linux 32 bit
  • Linux 64 bit
  • Linux ARM 32 bit