API for KWB-R/kwb.db
Functions supporting data base access

Global functions
.addClauseIfGiven Source code
.addSqlType Source code
.argumentsToConditions Source code
.argumentsToFieldNames Source code
.callWithMessages Source code
.commaNewlineCollapsed Source code
.dbDefault Source code
.getAlias Source code
.getFieldSchema Source code
.getForeignKeyName Source code
.getSqlType Source code
.getTable Source code
.getTableAndAlias Source code
.getTableNamesMatchingPattern Source code
.getTableSchema Source code
.getTableSchemata Source code
.grepValue Source code
.horizontalLine Source code
.hsJetType Source code
.hsMySqlType Source code
.introComment Source code
.looksLikeFullExpression Source code
.message_availableTables Source code
.namesAndValuesToConditions Source code
.newlineCollapsed Source code
.newlineSeparated Source code
.sqlEquals Source code
.sqlFieldIdentifier Source code
.sqlForeignKey Source code
.stopIfModeNotCharacterOrNumeric Source code
.stripPrefix Source code
.tableNameToFunctionName Source code
.toCondition Source code
.toExistingTableName Source code
.toSafeIndices Source code
argumentsToSqlParts Source code
clean_stop Source code
connectionStringAccess Man page Source code
createRDatabaseInterface Man page
currentDb Man page Source code
dataFrameToSqlTuples Man page Source code
dumpDatabase Man page Source code
getCurrentSqlDialect Man page Source code
getDatabaseSchema Man page Source code
getFilteredRecords Man page Source code
getNamedExcelRanges Man page Source code
getSqlDialect Man page Source code
getTypeIdentifier Man page Source code
get_odbc_function Source code
hsClearTable Man page Source code
hsCloseDb Man page Source code
hsCloseMdb Man page Source code
hsDropTable Man page Source code
hsDumpMdb Man page Source code
hsFields Man page Source code
hsGetTable Man page Source code
hsGetTimeSeries Man page Source code
hsJetDate Man page Source code
hsLookupOrAddRecord Man page
hsMdbTimeSeries Man page Source code
hsOpenDb Man page Source code
hsOpenMdb Man page Source code
hsPutTable Man page Source code
hsSetForeignKey Man page Source code
hsSetPrimaryKey Man page Source code
hsSqlExAnd Man page Source code
hsSqlExOr Man page Source code
hsSqlExTimeCond Man page Source code
hsSqlExTimeGroup Man page Source code
hsSqlExTsFields Man page Source code
hsSqlQuery Man page Source code
hsTables Man page Source code
hsTsField Man page Source code
is64BitR Source code
isAccess2003File Source code
isAccess2007File Source code
isAccessFile Source code
isExcel2003File Man page Source code
isExcel2007File Man page Source code
isExcelFile Man page Source code
isMySQL Man page Source code
isOdbcDataSource Source code
keyValueToSql Man page Source code
keyValuesToSql Man page Source code
keyValuesToSqlAssignment Man page Source code
keyValuesToSqlAssignment2 Man page Source code
keyValuesToSqlFilter Man page Source code
listValuesToSql Man page Source code
lookupRecord Man page Source code
odbcConnectionAccess Source code
odbcConnectionAccess32 Source code
odbcConnectionAccess64 Source code
odbcConnectionExcel Source code
odbcConnectionExcel32 Source code
openAdequateConnectionOrStop Man page Source code
printDatabaseSchema Man page Source code
rcode_DatabaseInterface Man page Source code
rcode_createRecord Source code
rcode_tableAccess Source code
readSqlCommandsFromFile Man page Source code
renamesToFieldList Man page Source code
renamesToQueries Man page Source code
runSqlCommandsFromFile Man page Source code
safeTableName Man page Source code
selectFromDb Man page Source code
selectFromTable Man page Source code
setCurrentDb Man page Source code
setCurrentSqlDialect Man page Source code
singleValueToSql Source code
sqlDateExpression Source code
sqlForInsert Man page Source code
sqlForInsertDataFrame Man page Source code
sqlForInsertFromSelect Man page Source code
sqlForInsertIgnoreInMsAccess Man page Source code
sqlForSelect Man page Source code
sqlForSelectByKey Man page Source code
sqlForUpdate Man page Source code
sqlFullLeftJoin Man page Source code
sqlJoinExpression Man page Source code
sqlLeftJoin Man page Source code
sqlLeftJoinBody Man page Source code
sqlLeftJoinExpression Man page Source code
valueToSqlOperator Source code
xmdb Man page Source code
KWB-R/kwb.db documentation built on Nov. 7, 2019, 1:14 p.m.