select records from tblkommentar

Source: R/kurasDbInterface.R

select and filter records from tblkommentar

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