|
connectionStringAccess()
|
Connection String Access |
|
createRDatabaseInterface()
|
Create R-Function Interface to Database |
|
currentDb()
|
Get Path to or Name of Current Database |
|
dataFrameToSqlTuples()
|
Create SQL Tuples from Data Frame |
|
dumpDatabase()
|
Export Database Tables to CSV Files |
|
getCurrentSqlDialect()
|
Get Current SQL Dialect |
|
getDatabaseSchema()
|
Get Database Schema |
|
getFilteredRecords()
|
Get Filtered Records |
|
getNamedExcelRanges()
|
Get Named Ranges from Excel File |
|
getSqlDialect()
|
Get SQL Dialect from Given Database |
|
getTypeIdentifier()
|
Get Type Identifier |
|
hsClearTable()
|
Clear a Database Table |
|
hsCloseDb()
|
Close Connection to MS Access or Excel |
|
hsCloseMdb()
|
Close Connection |
|
hsDropTable()
|
Drop Database Table(s) |
|
hsDumpMdb()
|
Export Database Tables to CSV Files |
|
hsFields()
|
Available Fields in Database Table |
|
hsGetTable()
|
Get Table from MS Access Database |
|
hsGetTimeSeries()
|
Get Time Series With Timestamp Info |
|
hsJetDate()
|
Date to “mm/dd/yyyy HH:MM:SS” |
|
hsLookupOrAddRecord()
|
Lookup or Add Record |
|
hsMdbTimeSeries()
|
Get Mdb time series in UTC |
|
hsOpenDb()
|
Open Connection to MS Access or Excel |
|
hsOpenMdb()
|
Open Connection to MS Access Database |
|
hsPutTable()
|
Save Data Frame to Database Table |
|
hsSetForeignKey()
|
Set Foreign Key for Table Field |
|
hsSetPrimaryKey()
|
Set Primary Key of Database Table |
|
hsSqlExAnd()
|
SQL Expression “AND” |
|
hsSqlExOr()
|
SQL Expression “OR” |
|
hsSqlExTimeCond()
|
SQL Expression: Time Period |
|
hsSqlExTimeGroup()
|
SQL Expression: Time Grouping |
|
hsSqlExTsFields()
|
SQL Expression: Timestamp Info |
|
hsSqlQuery()
|
Send SQL Query to Database |
|
hsTables()
|
Available tables in database |
|
hsTsField()
|
Available timestamp-field(s) in database table |
|
isExcel2003File()
|
Is this an XLS file? |
|
isExcel2007File()
|
Is this an XLSX file? |
|
isExcelFile()
|
Is this an Excel file? |
|
isMySQL()
|
Is the Given Database of Type MySQL? |
|
keyValueToSql()
|
Generate SQL Filter or Assignment Expression |
|
keyValuesToSql()
|
List of Key = Value Pairs to SQL Expressions |
|
keyValuesToSqlAssignment()
|
List of Key = Value Pairs to SQL Assignment |
|
keyValuesToSqlAssignment2()
|
Key Values to SQL Assignment (2) |
|
keyValuesToSqlFilter()
|
List of Key = Value Pairs to SQL Filter Expression |
|
listValuesToSql()
|
Create SQL Tuples from a List |
|
lookupRecord()
|
Lookup Record |
|
openAdequateConnectionOrStop()
|
Open Adequate Connection or Stop |
|
printDatabaseSchema()
|
Print Database Schema |
|
rcode_DatabaseInterface()
|
R-code for Functions to Access Database Tables |
|
readSqlCommandsFromFile()
|
Read SQL Commands from File |
|
renamesToFieldList()
|
List of Renamings to Field Selection String |
|
renamesToQueries()
|
List of Renamings to SQL Queries |
|
runSqlCommandsFromFile()
|
Run SQL Commands from File |
|
safeTableName()
|
Safe Table Name |
|
selectFromDb()
|
Select from Database |
|
selectFromTable()
|
Select from Table |
|
setCurrentDb()
|
Set Current Database |
|
setCurrentSqlDialect()
|
Set Current SQL Dialect |
|
sqlForInsert()
|
Generate SQL INSERT statement |
|
sqlForInsertDataFrame()
|
Generate SQL INSERT Statement |
|
sqlForInsertFromSelect()
|
SQL for INSERT FROM SELECT |
|
sqlForInsertIgnoreInMsAccess()
|
SQL for "INSERT IGNORE" in MS Access |
|
sqlForSelect()
|
Generate SQL SELECT statement#' |
|
sqlForSelectByKey()
|
Generate SQL SELECT Statement |
|
sqlForUpdate()
|
Generate SQL UPDATE Statement |
|
sqlFullLeftJoin()
|
Merge SQL Queries to One Query That Performs a Full Left Join |
|
sqlJoinExpression()
|
Create an SQL JOIN Expression |
|
sqlLeftJoin()
|
Generate SQL for LEFT JOIN |
|
sqlLeftJoinBody()
|
Generate (Base Part of) SQL for LEFT JOIN |
|
sqlLeftJoinExpression()
|
Create an SQL LEFT JOIN Expression |
|
xmdb()
|
Path to example database |