lookupRecord: Lookup Record

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

Lookup Record

Description

Looks up a record in a database table and returns the ID of the record or NULL if the record does not exist.

Usage

lookupRecord(
  db,
  tableName,
  keyAssignments,
  idField = hsFields(db, tableName)[1],
  dbg = FALSE,
  use2007Driver = NULL
)

Arguments

db	full path to MS Access/Excel database or name of ODBC data source
tableName	name of table in which record is to be looked up
keyAssignments	key-value-assignments 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").
idField	name of ID field, default: name of first table field
dbg	if TRUE, debug messages are shown
use2007Driver	passed to isMySQL

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