sqlForUpdate: Generate SQL UPDATE Statement

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

Generate SQL UPDATE Statement

Description

Generate SQL UPDATE Statement

Usage

sqlForUpdate(tablename, keyValues, whereClause, ignore = FALSE)

Arguments

tablename	table name
keyValues	assignments as list of key=value pairs with the keys representing valid fields of table tablename
whereClause	where condition
ignore	if TRUE the keyword IGNORE is inserted between UPDATE and INTO in the SQL statement -> no error will be given if updating fails, e.g. because of key constraints

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