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 |
| check_xml2 | 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 |
| getDatabaseFieldInfo | 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_attributes | Source code |
| get_field_info | Source code |
| get_index_info | Source code |
| get_max_length | 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 |
| merge_relations | Man page Source code |
| odbcConnectionAccess | Source code |
| odbcConnectionExcel | 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 |
| read_relations | Man page Source code |
| read_schema | Source code |
| read_schemata | Man page Source code |
| reduce_to_relevant | 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 |
