hsLookupOrAddRecord: Lookup or Add Record

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

Lookup or Add Record

Description

Looks up a record in a database table and returns the ID of the record. If the record is not found it is inserted to the table and the ID of the new record is returned.

Usage

hsLookupOrAddRecord(
  mdb,
  tbl,
  keyAssigns,
  fieldAssigns = NULL,
  idField = hsFields(mdb, tbl)[1],
  dbg = FALSE
)

Arguments

mdb	full path to MS Access database
tbl	name of table in which record is to be looked up
keyAssigns	key-value-assignements used to identify the record to be looked up. The assignments are defined in forms of a list, e.g. list(key1 = "value1", key2 = "value2").
fieldAssigns	further field-value-assignements used when a new record needs to be inserted. The assignments are defined in forms of a list, e.g. list(field1 = "value1", field2 = "value2").
idField	name of ID field, default: name of first table field
dbg	if TRUE, debug messages are shown

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