Platforms to show: All Mac Windows Linux Cross-Platform

The plugin MBS DuckDB Plugin:

• class DuckConnectionMBS
  • method Constructor
  • method Destructor
  • method SQLSelect(SQL as String) as DuckResultMBS
  • method SQLExecute(SQL as String) as Boolean
  • method Prepare(SQL as String) as DuckPreparedStatementMBS
  • method BeginTransaction as Boolean
  • method Commit as Boolean
  • method Rollback as Boolean
  • property Handle as Integer
  • property Database as DuckDatabaseMBS
  • property ErrorMessage as String
• class DuckDatabaseMBS
  • method Constructor(path as String = "")
  • method Constructor(file as FolderItem)
  • method Destructor
  • method Connect as DuckConnectionMBS
  • property Handle as Integer
  • shared method LoadLibrary(file as folderitem) as boolean
  • shared method LoadLibrary(path as string) as boolean
  • shared method LibraryLoadErrorMessage as String
  • shared method LibraryLoadError as Integer
  • shared method LibraryLoaded as Boolean
  • shared property HasBuiltInLibrary as Boolean
• class DuckPreparedStatementMBS
  • method Constructor
  • method Destructor
  • method SQLSelect as DuckResultMBS
  • method SQLExecute as Boolean
  • method BindBoolean(index as Integer, value as Boolean)
  • method BindInt8(index as Integer, value as Int8)
  • 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 BindFloat(index as Integer, value as Single)
  • method BindDouble(index as Integer, value as Double)
  • method BindString(index as Integer, value as String)
  • method BindValue(index as Integer, value as Variant)
  • method BindNull(index as Integer)
  • method BindValues(values() as Variant)
  • method BindBlob(index as Integer, value as MemoryBlock)
  • method BindBlob(index as Integer, value as String)
  • property Handle as Integer
  • property Connection as DuckConnectionMBS
  • property ParamCount as Integer
  • property ErrorMessage as String
• class DuckResultMBS
  • method ColumnValues(Column as Integer) as Variant()
  • method RowValues(Row as Integer) as Variant()
  • method Constructor
  • method Destructor
  • method ColumnName(Column as Integer) as String
  • method ColumnIndex(ColumnName as String) as Integer
  • method Value(Column as Integer, Row as Integer) as Variant
  • method ValueBoolean(Column as Integer, Row as Integer) as Boolean
  • method ValueInt8(Column as Integer, Row as Integer) as Int8
  • 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 ValueSingle(Column as Integer, Row as Integer) as Single
  • method ValueDouble(Column as Integer, Row as Integer) as Double
  • method ValueString(Column as Integer, Row as Integer) as String
  • method ValueInterval(Column as Integer, Row as Integer, byref Months as Integer, byref Days as Integer, byref MilliSeconds as Int64) as Boolean
  • method ValueHugeInt(Column as Integer, Row as Integer, byref lower as UInt64, byref upper as Int64) as Boolean
  • method ColumnType(Column as Integer) as Integer
  • method IsNull(Column as Integer, Row as Integer) as Boolean
  • method ValueDate(Column as Integer, Row as Integer, byref Year as Integer, byref Month as Integer, byref Day as Integer) as Boolean
  • 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
  • method ValueDate(Column as Integer, Row as Integer) as Date
  • method ValueDateTime(Column as Integer, Row as Integer) as DateTime
  • property Handle as Integer
  • property Connection as DuckConnectionMBS
  • property ColumnCount as Integer
  • property RowCount as Integer

Feedback: Report problem or ask question.