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