listValuesToSql: Create SQL Tuples from a List

In KWB-R/kwb.db: Functions supporting data base access

Create SQL Tuples from a List

Description

Create SQL Tuples from a List

Usage

listValuesToSql(x)

Arguments

x	a list defining key = value pairs

Value

vector of character strings each of which represents one assignment in x

Examples

x <- list(name = "Peter", birthday = as.POSIXct("1981-12-13"))

setCurrentSqlDialect("msaccess")
cat(listValuesToSql(x))

# Note that the representation of a date and time is different in MySQL
setCurrentSqlDialect("mysql")
cat(listValuesToSql(x))

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.