Skip to contents

select records from tblinstitution

Source: R/kurasDbInterface.R
kuras_institution.Rd

select and filter records from tblinstitution

Usage

kuras_institution(
  where = NULL,
  where_inID = NA,
  where_inName = NA,
  where_inKurzname = NA,
  where_inAdresse = NA,
  where_inBeschreibung = NA,
  select = NULL,
  select_inID = NA,
  select_inName = NA,
  select_inKurzname = NA,
  select_inAdresse = NA,
  select_inBeschreibung = NA,
  orderBy = NULL,
  orderBy_inID = NA,
  orderBy_inName = NA,
  orderBy_inKurzname = NA,
  orderBy_inAdresse = NA,
  orderBy_inBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_inID

condition for field inID: Enter a field description here

where_inName

condition for field inName: Enter a field description here

where_inKurzname

condition for field inKurzname: Enter a field description here

where_inAdresse

condition for field inAdresse: Enter a field description here

where_inBeschreibung

condition for field inBeschreibung: Enter a field description here

select

fields/expressions to select

select_inID

select field inID?

select_inName

select field inName?

select_inKurzname

select field inKurzname?

select_inAdresse

select field inAdresse?

select_inBeschreibung

select field inBeschreibung?

orderBy

ORDER BY clause of SQL expression

orderBy_inID

order by field inID?

orderBy_inName

order by field inName?

orderBy_inKurzname

order by field inKurzname?

orderBy_inAdresse

order by field inAdresse?

orderBy_inBeschreibung

order by field inBeschreibung?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable