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