select
and filter records from tblreferenz
Usage
kuras_referenz(
where = NULL,
where_rID = NA,
where_rNachname = NA,
where_rVorname = NA,
where_rJahr = NA,
where_rArt = NA,
where_rTitel = NA,
where_rTitelMedium = NA,
where_rZusatz = NA,
where_rBeschreibung = NA,
where_rQualitaet = NA,
select = NULL,
select_rID = NA,
select_rNachname = NA,
select_rVorname = NA,
select_rJahr = NA,
select_rArt = NA,
select_rTitel = NA,
select_rTitelMedium = NA,
select_rZusatz = NA,
select_rBeschreibung = NA,
select_rQualitaet = NA,
orderBy = NULL,
orderBy_rID = NA,
orderBy_rNachname = NA,
orderBy_rVorname = NA,
orderBy_rJahr = NA,
orderBy_rArt = NA,
orderBy_rTitel = NA,
orderBy_rTitelMedium = NA,
orderBy_rZusatz = NA,
orderBy_rBeschreibung = NA,
orderBy_rQualitaet = NA,
db = "KURAS",
...
)
Arguments
- where
WHERE condition
- where_rID
condition for field rID: Enter a field description here
- where_rNachname
condition for field rNachname: Enter a field description here
- where_rVorname
condition for field rVorname: Enter a field description here
- where_rJahr
condition for field rJahr: Enter a field description here
- where_rArt
condition for field rArt: Enter a field description here
- where_rTitel
condition for field rTitel: Enter a field description here
- where_rTitelMedium
condition for field rTitelMedium: Enter a field description here
- where_rZusatz
condition for field rZusatz: Enter a field description here
- where_rBeschreibung
condition for field rBeschreibung: Enter a field description here
- where_rQualitaet
condition for field rQualitaet: Enter a field description here
- select
fields/expressions to
select
- select_rID
select
field rID?- select_rNachname
select
field rNachname?- select_rVorname
select
field rVorname?- select_rJahr
select
field rJahr?- select_rArt
select
field rArt?- select_rTitel
select
field rTitel?- select_rTitelMedium
select
field rTitelMedium?- select_rZusatz
select
field rZusatz?- select_rBeschreibung
select
field rBeschreibung?- select_rQualitaet
select
field rQualitaet?- orderBy
ORDER BY clause of SQL expression
- orderBy_rID
order by field rID?
- orderBy_rNachname
order by field rNachname?
- orderBy_rVorname
order by field rVorname?
- orderBy_rJahr
order by field rJahr?
- orderBy_rArt
order by field rArt?
- orderBy_rTitel
order by field rTitel?
- orderBy_rTitelMedium
order by field rTitelMedium?
- orderBy_rZusatz
order by field rZusatz?
- orderBy_rBeschreibung
order by field rBeschreibung?
- orderBy_rQualitaet
order by field rQualitaet?
- db
name of ODBC data source, default:
"KURAS"
- ...
additional arguments passed to
kwb.db::selectFromTable