1010data VBA SDK
 All Data Structures Files Functions Variables
include/vbasdk1010.bas
Attribute VB_Name = "VBASDK1010"
Option Explicit
Public Const TENTEN_SDK_VERSION As Long = 20150806
Public Const TENTEN_THREAD_RESULTS As String = "..."
Public Const TENTEN_ERROR_OUT_OF_MEMORY As Long = -10
Public Const TENTEN_ERROR_INVALID_HANDLE As Long = -11
Public Const TENTEN_ERROR_INVALID_QUERY As Long = -12
Public Const TENTEN_ERROR_INVALID_ARGS As Long = -13
Public Const TENTEN_ERROR_NOT_FOUND As Long = -14
Public Const TENTEN_ERROR_UNSUPPORTED_TYPE As Long = -15
Public Const TENTEN_ERROR_NO_RESULTS As Long = -16
Public Const TENTEN_ERROR_INVALID_DATA As Long = -17
Public Const TENTEN_ERROR_THREAD_RUNNING As Long = -20
Public Const TENTEN_ERROR_THREAD_CREATE As Long = -21
Public Const TENTEN_ERROR_ARRAY_CREATE As Long = -22
Public Const TENTEN_ERROR_ARRAY_ACCESS As Long = -23
Public Const TENTEN_ERROR_ARRAY_REDIM As Long = -24
Public Const TENTEN_KILL As Long = 1
Public Const TENTEN_NO_KILL As Long = 0
Public Const TENTEN_POSSESS As Long = -1
Public Const TENTEN_ALL_COLUMNS As Long = 0
Public Const TENTEN_NO_CHANGE As Long = -2
Public Const TENTEN_INHERIT As Long = -1
Public Const TENTEN_PRIVATE As Long = 0
Public Const TENTEN_NO_MAXDOWN As Long = 0
Public Const TENTEN_TITLE As Long = &H1
Public Const TENTEN_SDESC As Long = &H2
Public Const TENTEN_LDESC As Long = &H4
Public Const TENTEN_SECURE As Long = &H10
Public Const TENTEN_OWNER As Long = &H40
Public Const TENTEN_FORMATTED_STRINGS As Long = &H1
Public Const TENTEN_RAW_DATA As Long = &H2
Public Const TENTEN_ONE_INDEXED As Long = &H4
Public Const TENTEN_ONE_DIM As Long = &H8
Public Const TENTEN_EXCEL_DATA As Long = &H10
Public Const TENTEN_NO_FLAGS As Long = &H0
Public Const TENTEN_ADDTAB_IDLE As Long = 0
Public Const TENTEN_ADDTAB_FAILED As Long = 1
Public Const TENTEN_ADDTAB_INITIALIZING As Long = 2
Public Const TENTEN_ADDTAB_LOADING As Long = 3
Public Const TENTEN_ADDTAB_COMPLETED As Long = 4
Public Const TENTEN_ADDTAB_DIAGNOSED As Long = 5
Public Const TENTEN_THREAD_STILL_ACTIVE As Long = 259
Public Type TentenTabDir
name As String
title As String
sdesc As String
ldesc As String
link As String
update As Date
owner As String
tabletype As String
secure As Boolean
own As Boolean
istable As Boolean
upload As Boolean
access As Boolean
tstat As Boolean
maxdown As Double
rows As Double
bytes As Double
segs As Long
id As Long
End Type
Public Type TentenColumn
name As String
title As String
datatype As String
formattype As String
width As Long
dec As Long
unit As String
End Type
Public Type TentenProgress
numops As Long
activeop As Long
percentage As Double
memory As Double
op As String
End Type
Public Declare PtrSafe Sub TentenInit Lib "lib1010vbasdk.dll" ()
Public Declare PtrSafe Sub TentenTearDown Lib "lib1010vbasdk.dll" ()
Public Declare PtrSafe Function TentenSDKVersion Lib "lib1010vbasdk.dll" () As Double
Public Declare PtrSafe Function TentenLatestVersion Lib "lib1010vbasdk.dll" (ByVal location As String) As Long
Public Declare PtrSafe Sub TentenSetUserAgent Lib "lib1010vbasdk.dll" (ByVal useragent As String)
Public Declare PtrSafe Sub TentenGetUserAgent Lib "lib1010vbasdk.dll" ( ByRef useragent As String)
Public Declare PtrSafe Sub TentenSetAPIVersion Lib "lib1010vbasdk.dll" (ByVal apiversion As String)
Public Declare PtrSafe Sub TentenGetAPIVersion Lib "lib1010vbasdk.dll" (ByRef apiversion As String)
Public Declare PtrSafe Function TentenNewHandle Lib "lib1010vbasdk.dll" () As Long
Public Declare PtrSafe Sub TentenFreeHandle Lib "lib1010vbasdk.dll" (ByVal ttsid As Long)
Public Declare PtrSafe Function TentenEnableLog Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal filename As String, ByVal append As Boolean) As Long
Public Declare PtrSafe Function TentenDisableLog Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Sub TentenGetSessionCredentials Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef sid As String, ByRef epw As String)
Public Declare PtrSafe Sub TentenSetHandleUserAgent Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal useragent As String)
Public Declare PtrSafe Sub TentenGetHandleUserAgent Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef useragent As String)
Public Declare PtrSafe Sub TentenSetHandleAPIVersion Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal apiversion As String)
Public Declare PtrSafe Sub TentenGetHandleAPIVersion Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef apiversion As String)
Public Declare PtrSafe Function TentenSetExpBackoff Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal retryMax As Long, ByVal retryTimeMin As Long, ByVal retryTimeRange As Long, ByVal retryBase As Double) As Long
Public Declare PtrSafe Sub TentenGetExpBackoff Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef retryMax As Long, ByRef retryTimeMin As Long, ByRef retryTimeRange As Long, ByRef retryBase As Double)
Public Declare PtrSafe Function TentenSetTimeout Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal connectTimeout As Long, ByVal timeout As Long) As Long
Public Declare PtrSafe Sub TentenGetTimeout Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef connectTimeout As Long, ByRef timeout As Long)
Public Declare PtrSafe Sub TentenSetLenient Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal lenient As Long)
Public Declare PtrSafe Function TentenRC Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Sub TentenMsg Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef msg As String)
Public Declare PtrSafe Sub TentenSystemVersion Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef sysver As String)
Public Declare PtrSafe Function TentenLogin Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal url As String, ByVal user As String, ByVal password As String, ByVal killp As Long) As Long
Public Declare PtrSafe Function TentenLoginThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal url As String, ByVal user As String, ByVal password As String, ByVal killp As Long) As Long
Public Declare PtrSafe Function TentenCheckThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef rc As Long) As Long
Public Declare PtrSafe Function TentenGetUID Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal url As String, ByVal owner As String, ByVal group As String, ByVal password As String) As Long
Public Declare PtrSafe Function TentenGetUIDThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal url As String, ByVal owner As String, ByVal group As String, ByVal password As String) As Long
Public Declare PtrSafe Function TentenLoginUID Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal password As String, ByVal killp As Long) As Long
Public Declare PtrSafe Function TentenLoginUIDThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal password As String, ByVal killp As Long) As Long
Public Declare PtrSafe Function TentenLogout Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenLogoutThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenReleaseUID Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenReleaseUIDThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenDuplicateSession Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal url As String, ByVal user As String, ByVal sid As String, ByVal epw As String) As Long
Public Declare PtrSafe Function TentenDuplicateSessionThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal url As String, ByVal user As String, ByVal sid As String, ByVal epw As String) As Long
Public Declare PtrSafe Function TentenClearCache Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenClearCacheThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenCurrMem Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Double
Public Declare PtrSafe Function TentenNewQuery Lib "lib1010vbasdk.dll" () As Long
Public Declare PtrSafe Sub TentenFreeQuery Lib "lib1010vbasdk.dll" (ByVal qid As Long)
Public Declare PtrSafe Sub TentenSetTable Lib "lib1010vbasdk.dll" (ByVal qid As Long, ByVal tablepath As String)
Public Declare PtrSafe Sub TentenSetOps Lib "lib1010vbasdk.dll" (ByVal qid As Long, ByVal ops As String)
Public Declare PtrSafe Function TentenExecuteQuery Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal qid As Long) As Long
Public Declare PtrSafe Function TentenNumCols Lib "lib1010vbasdk.dll" (ByVal qid As Long) As Long
Public Declare PtrSafe Function TentenNumRows Lib "lib1010vbasdk.dll" (ByVal qid As Long) As Double
Public Declare PtrSafe Function TentenGetColumnInfo Lib "lib1010vbasdk.dll" (ByVal qid As Long, ByRef colinfo() As TentenColumn) As Long
Public Declare PtrSafe Function TentenExecuteQueryThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal qid As Long) As Long
Public Declare PtrSafe Function TentenCheckProgress Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef progress As TentenProgress, ByVal logxml As Boolean) As Long
Public Declare PtrSafe Function TentenStop Lib "lib1010vbasdk.dll" (ByVal ttsid As Long) As Long
Public Declare PtrSafe Function TentenGetRows Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal qid As Long, ByVal compression As Boolean, ByRef colnames As Variant, ByVal firstrow As Double, ByVal nrowstoget As Long, ByRef nrowsgotten As Long) As Long
Public Declare PtrSafe Function TentenGetColumnData Lib "lib1010vbasdk.dll" (ByVal qid As Long, ByVal colname As String, ByRef var As Variant, ByVal flags As Long) As Long
Public Declare PtrSafe Function TentenGetRowsThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal qid As Long, ByVal compression As Boolean, ByRef colnames As Variant, ByVal firstrow As Double, ByVal nrowstoget As Long) As Long
Public Declare PtrSafe Function TentenNumRowsGotten Lib "lib1010vbasdk.dll" (ByVal qid As Long, ByVal colname As String) As Long
Public Declare PtrSafe Function TentenUploadXMLTable Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String, ByVal xml As String) As Long
Public Declare PtrSafe Function TentenUploadXMLTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String, ByVal xml As String) As Long
Public Declare PtrSafe Function TentenSaveToFTP Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal filename As String, ByVal namesp As Boolean, ByVal headersp As Boolean, ByVal sep As String, ByVal linesep As String) As Long
Public Declare PtrSafe Function TentenSaveToFTPThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal filename As String, ByVal namesp As Boolean, ByVal headersp As Boolean, ByVal sep As String, ByVal linesep As String) As Long
Public Declare PtrSafe Function TentenSaveTable Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef table As TentenTabDir, ByVal replacep As Boolean, ByVal appendp As Boolean, ByVal appendablep As Boolean, ByVal temporaryp As Boolean, ByRef permissions As Variant) As Long
Public Declare PtrSafe Function TentenSaveTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef table As TentenTabDir, ByVal replacep As Boolean, ByVal appendp As Boolean, ByVal appendablep As Boolean, ByVal temporaryp As Boolean, ByRef permissions As Variant) As Long
Public Declare PtrSafe Function TentenMergeTables Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef tablenames() As String, ByRef table As TentenTabDir, ByVal replacep As Boolean, ByRef permissions As Variant) As Long
Public Declare PtrSafe Function TentenMergeTablesThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef tablenames() As String, ByRef table As TentenTabDir, ByVal replacep As Boolean, ByRef permissions As Variant) As Long
Public Declare PtrSafe Function TentenMoveTable Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal oldpath As String, ByVal newpath As String) As Long
Public Declare PtrSafe Function TentenMoveTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal oldpath As String, ByVal newpath As String) As Long
Public Declare PtrSafe Function TentenDropTable Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String) As Long
Public Declare PtrSafe Function TentenDropTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String) As Long
Public Declare PtrSafe Function TentenModifyTable Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef table As TentenTabDir, ByVal flags As Long, ByRef permissions As Variant) As Long
Public Declare PtrSafe Function TentenModifyTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef table As TentenTabDir, ByVal flags As Long, ByRef permissions As Variant) As Long
Public Declare PtrSafe Function TentenGetTableInfo Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String, ByRef table As TentenTabDir, ByRef colinfo() As TentenColumn) As Long
Public Declare PtrSafe Function TentenGetTableInfoThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String) As Long
Public Declare PtrSafe Function TentenGetTableMetaInfo Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String, ByRef table As TentenTabDir) As Long
Public Declare PtrSafe Function TentenGetTableMetaInfoThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal tablename As String) As Long
Public Declare PtrSafe Function TentenGetDirectory Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal dirname As String, ByVal descendants As Boolean, ByRef dir As TentenTabDir, ByRef parents() As TentenTabDir, ByRef children() As TentenTabDir) As Long
Public Declare PtrSafe Function TentenGetDirectoryThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal dirname As String, ByVal descendants As Boolean) As Long
Public Declare PtrSafe Function TentenModifyDirectory Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef dir As TentenTabDir, ByVal flags As Long, ByRef users As Variant, ByRef uploaders As Variant) As Long
Public Declare PtrSafe Function TentenModifyDirectoryThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef dir As TentenTabDir, ByVal flags As Long, ByRef users As Variant, ByRef uploaders As Variant) As Long
Public Declare PtrSafe Function TentenGetQueryOps Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal pathname As String, ByRef base As String, ByRef ops As String) As Long
Public Declare PtrSafe Function TentenGetQueryOpsThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal pathname As String) As Long
Public Declare PtrSafe Function TentenConvertSpec Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal filename As String, ByRef spec As String) As Long
Public Declare PtrSafe Function TentenConvertSpecThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal filename As String) As Long
Public Declare PtrSafe Function TentenValidateSpec Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String) As Long
Public Declare PtrSafe Function TentenValidateSpecThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String) As Long
Public Declare PtrSafe Function TentenAddTable Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String, ByRef pathname As String) As Long
Public Declare PtrSafe Function TentenAddTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String) As Long
Public Declare PtrSafe Function TentenAddTableAsync Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String, ByRef pathname As String) As Long
Public Declare PtrSafe Function TentenAddTableStatus Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef status As Long, ByRef numrecs As Double, ByRef totrecs As Double) As Long
"code" href="vbasdk1010_8h.html#af6c1f3d80d6cdd110ebcc1732e13c08b" title="Loads a table into 1010data from the user's 1010data FTP account.">TentenAddTableThread Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String) As Long
Public Declare PtrSafe Function TentenAddTableAsync Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByVal spec As String, ByRef pathname As String) As Long
Public Declare PtrSafe Function TentenAddTableStatus Lib "lib1010vbasdk.dll" (ByVal ttsid As Long, ByRef status As Long, ByRef numrecs As Double, ByRef totrecs As Double) As Long