Skip to contents

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