Platforms to show: All Mac Windows Linux Cross-Platform

DuckResultMBS class

Type Topic Plugin Version macOS Windows Linux iOS Targets
class DuckDB MBS DuckDB Plugin 21.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: The class for a DuckDB result.
Notes: This is an abstract class. You can't create an instance, but you can get one from various plugin functions.

Feedback, Comments & Corrections

  • 4 properties
  • 23 methods
    • method ColumnIndex(ColumnName as String) as Integer
    • method ColumnName(Column as Integer) as String
    • method ColumnType(Column as Integer) as Integer
    • method ColumnValues(Column as Integer) as Variant()
    • method Constructor
    • method Destructor
    • method IsNull(Column as Integer, Row as Integer) as Boolean
    • method RowValues(Row as Integer) as Variant()
    • method Value(Column as Integer, Row as Integer) as Variant
    • method ValueBoolean(Column as Integer, Row as Integer) as Boolean
    • method ValueDate(Column as Integer, Row as Integer) as Date
    • method ValueDate(Column as Integer, Row as Integer, byref Year as Integer, byref Month as Integer, byref Day as Integer) as Boolean
    • method ValueDateTime(Column as Integer, Row as Integer) as DateTime
    • method ValueDouble(Column as Integer, Row as Integer) as Double
    • method ValueHugeInt(Column as Integer, Row as Integer, byref lower as UInt64, byref upper as Int64) as Boolean
    • method ValueInt16(Column as Integer, Row as Integer) as Int16
    • method ValueInt32(Column as Integer, Row as Integer) as Int32
    • method ValueInt64(Column as Integer, Row as Integer) as Int64
    • method ValueInt8(Column as Integer, Row as Integer) as Int8
    • method ValueInterval(Column as Integer, Row as Integer, byref Months as Integer, byref Days as Integer, byref MilliSeconds as Int64) as Boolean
    • method ValueSingle(Column as Integer, Row as Integer) as Single
    • method ValueString(Column as Integer, Row as Integer) as String
    • method ValueTime(Column as Integer, Row as Integer, byref Hour as Integer, byref Minute as Integer, byref Second as Integer, byref MilliSeconds as Integer) as Boolean
  • 14 constants

Types

Constant Value Description
TypeBoolean 1 Boolean
TypeDate 9 Date
TypeDouble 7 64-bit Double precision floating point
TypeHugeInt 12 128-bit Integer
TypeInt16 3 16-bit Integer
TypeInt32 4 32-bit Integer
TypeInt64 5 64-bit Integer
TypeInt8 2 8-bit Integer
TypeInterval 11 Interval
TypeInvalid 0 No value
TypeSingle 6 32-bit Single precision floating point
TypeString 13 Varchar
TypeTime 10 Time
TypeTimestamp 8 Date and Time

This class has no sub classes.

Some methods using this class:

Some examples using this class:

Blog Entries


The items on this page are in the following plugins: MBS DuckDB Plugin.


DuckPreparedStatementMBS   -   DVDPlaybackMBS

The biggest plugin in space...




Links
MBS FileMaker blog

Start Chat