sqlForSelectByKey: Generate SQL SELECT Statement

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

Generate SQL SELECT Statement

Description

Generate SQL SELECT statement (key field values instead of where clause)

Usage

sqlForSelectByKey(tablename, fields = "*", keyValues = NULL)

Arguments

tablename	table name
fields	expression to select fields; field names are separated by comma and alias names may be used, just as SQL accepts, e.g.: "tstamp as myDateTime, parVal as myValue"; Default: "*"
keyValues	list of "key=value" pairs with the keys being valid field names of table

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