Skip to contents

select and filter records from tblperson

Usage

kuras_person(
  where = NULL,
  where_pnID = NA,
  where_pnInitialien = NA,
  where_pnVorname = NA,
  where_pnNachname = NA,
  where_pnInstitutionID = NA,
  where_pnAdresse = NA,
  where_pnTelefon = NA,
  select = NULL,
  select_pnID = NA,
  select_pnInitialien = NA,
  select_pnVorname = NA,
  select_pnNachname = NA,
  select_pnInstitutionID = NA,
  select_pnAdresse = NA,
  select_pnTelefon = NA,
  orderBy = NULL,
  orderBy_pnID = NA,
  orderBy_pnInitialien = NA,
  orderBy_pnVorname = NA,
  orderBy_pnNachname = NA,
  orderBy_pnInstitutionID = NA,
  orderBy_pnAdresse = NA,
  orderBy_pnTelefon = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_pnID

condition for field pnID: Enter a field description here

where_pnInitialien

condition for field pnInitialien: Enter a field description here

where_pnVorname

condition for field pnVorname: Enter a field description here

where_pnNachname

condition for field pnNachname: Enter a field description here

where_pnInstitutionID

condition for field pnInstitutionID: Enter a field description here

where_pnAdresse

condition for field pnAdresse: Enter a field description here

where_pnTelefon

condition for field pnTelefon: Enter a field description here

select

fields/expressions to select

select_pnID

select field pnID?

select_pnInitialien

select field pnInitialien?

select_pnVorname

select field pnVorname?

select_pnNachname

select field pnNachname?

select_pnInstitutionID

select field pnInstitutionID?

select_pnAdresse

select field pnAdresse?

select_pnTelefon

select field pnTelefon?

orderBy

ORDER BY clause of SQL expression

orderBy_pnID

order by field pnID?

orderBy_pnInitialien

order by field pnInitialien?

orderBy_pnVorname

order by field pnVorname?

orderBy_pnNachname

order by field pnNachname?

orderBy_pnInstitutionID

order by field pnInstitutionID?

orderBy_pnAdresse

order by field pnAdresse?

orderBy_pnTelefon

order by field pnTelefon?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable