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