select records from tblreferenz

select and filter records from tblreferenz

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