Platforms to show: All Mac Windows Linux Cross-Platform

DuckDB

Classes for DuckDB engine.

• Classes
  • class DuckConnectionMBS
    • method BeginTransaction as Boolean
    • method Commit as Boolean
    • method Constructor
    • method Destructor
    • method Prepare(SQL as String) as DuckPreparedStatementMBS
    • method Rollback as Boolean
    • method SQLExecute(SQL as String) as Boolean
    • method SQLSelect(SQL as String) as DuckResultMBS
    • property Database as DuckDatabaseMBS
    • property ErrorMessage as String
    • property Handle as Integer
  • class DuckDatabaseMBS
    • method Connect as DuckConnectionMBS
    • method Constructor(file as FolderItem)
    • method Constructor(path as String = "")
    • method Destructor
    • shared method LibraryLoaded as Boolean
    • shared method LibraryLoadError as Integer
    • shared method LibraryLoadErrorMessage as String
    • shared method LoadLibrary(file as folderitem) as boolean
    • shared method LoadLibrary(path as string) as boolean
    • property Handle as Integer
    • shared property HasBuiltInLibrary as Boolean
    • const Version = "0.2.3"
  • class DuckPreparedStatementMBS
    • method BindBlob(index as Integer, value as MemoryBlock)
    • method BindBlob(index as Integer, value as String)
    • method BindBoolean(index as Integer, value as Boolean)
    • method BindDouble(index as Integer, value as Double)
    • method BindFloat(index as Integer, value as Single)
    • method BindInt16(index as Integer, value as Int16)
    • method BindInt32(index as Integer, value as Int32)
    • method BindInt64(index as Integer, value as Int64)
    • method BindInt8(index as Integer, value as Int8)
    • method BindNull(index as Integer)
    • method BindString(index as Integer, value as String)
    • method BindValue(index as Integer, value as Variant)
    • method BindValues(values() as Variant)
    • method Constructor
    • method Destructor
    • method SQLExecute as Boolean
    • method SQLSelect as DuckResultMBS
    • property Connection as DuckConnectionMBS
    • property ErrorMessage as String
    • property Handle as Integer
    • property ParamCount as Integer
  • class DuckResultMBS
    • 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
    • property ColumnCount as Integer
    • property Connection as DuckConnectionMBS
    • property Handle as Integer
    • property RowCount as Integer
    • const TypeBoolean = 1
    • const TypeDate = 9
    • const TypeDouble = 7
    • const TypeHugeInt = 12
    • const TypeInt16 = 3
    • const TypeInt32 = 4
    • const TypeInt64 = 5
    • const TypeInt8 = 2
    • const TypeInterval = 11
    • const TypeInvalid = 0
    • const TypeSingle = 6
    • const TypeString = 13
    • const TypeTime = 10
    • const TypeTimestamp = 8

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