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.
hsLookupOrAddRecord( mdb, tbl, keyAssigns, fieldAssigns = NULL, idField = hsFields(mdb, tbl)[1], dbg = FALSE )
| 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 |