Skip to contents

select and filter records from tbleffekt

Usage

kuras_effekt(
  where = NULL,
  where_eID = NA,
  where_eName = NA,
  where_eBeschreibung = NA,
  select = NULL,
  select_eID = NA,
  select_eName = NA,
  select_eBeschreibung = NA,
  orderBy = NULL,
  orderBy_eID = NA,
  orderBy_eName = NA,
  orderBy_eBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_eID

condition for field eID: Enter a field description here

where_eName

condition for field eName: Enter a field description here

where_eBeschreibung

condition for field eBeschreibung: Enter a field description here

select

fields/expressions to select

select_eID

select field eID?

select_eName

select field eName?

select_eBeschreibung

select field eBeschreibung?

orderBy

ORDER BY clause of SQL expression

orderBy_eID

order by field eID?

orderBy_eName

order by field eName?

orderBy_eBeschreibung

order by field eBeschreibung?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable