Skip to contents

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