Platforms to show: All Mac Windows Linux Cross-Platform
DuckResultMBS class deprecated
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| class | DuckDB | MBS DuckDB Plugin | 21.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
This item is deprecated and should no longer be used.
You can use RowSet or RecordSet instead.
Notes:
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.- 4 properties
- property ColumnCount as Integer
- property Connection as DuckConnectionMBS
- property Handle as Integer
- property RowCount as Integer
- 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 private
- 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:
- DuckConnectionMBS.SQLSelect(SQL as String) as DuckResultMBS
- DuckPreparedStatementMBS.SQLSelect as DuckResultMBS
Some examples using this class:
Blog Entries
The items on this page are in the following plugins: MBS DuckDB Plugin.
DuckPreparedStatementMBS - DVDPlaybackMBS
Feedback: Report problem or ask question.
