Skip to contents

select and filter records from tblkommentar

Usage

kuras_kommentar(
  where = NULL,
  where_kID = NA,
  where_kPersonID = NA,
  where_kDatum = NA,
  where_kBezugstabelle = NA,
  where_kDatensatzID = NA,
  where_kKommentar = NA,
  select = NULL,
  select_kID = NA,
  select_kPersonID = NA,
  select_kDatum = NA,
  select_kBezugstabelle = NA,
  select_kDatensatzID = NA,
  select_kKommentar = NA,
  orderBy = NULL,
  orderBy_kID = NA,
  orderBy_kPersonID = NA,
  orderBy_kDatum = NA,
  orderBy_kBezugstabelle = NA,
  orderBy_kDatensatzID = NA,
  orderBy_kKommentar = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_kID

condition for field kID: Enter a field description here

where_kPersonID

condition for field kPersonID: Enter a field description here

where_kDatum

condition for field kDatum: Enter a field description here

where_kBezugstabelle

condition for field kBezugstabelle: Enter a field description here

where_kDatensatzID

condition for field kDatensatzID: Enter a field description here

where_kKommentar

condition for field kKommentar: Enter a field description here

select

fields/expressions to select

select_kID

select field kID?

select_kPersonID

select field kPersonID?

select_kDatum

select field kDatum?

select_kBezugstabelle

select field kBezugstabelle?

select_kDatensatzID

select field kDatensatzID?

select_kKommentar

select field kKommentar?

orderBy

ORDER BY clause of SQL expression

orderBy_kID

order by field kID?

orderBy_kPersonID

order by field kPersonID?

orderBy_kDatum

order by field kDatum?

orderBy_kBezugstabelle

order by field kBezugstabelle?

orderBy_kDatensatzID

order by field kDatensatzID?

orderBy_kKommentar

order by field kKommentar?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable