Skip to contents

select and filter records from tblanlageeigenschaftswert

Usage

kuras_anlageeigenschaftswert(
  where = NULL,
  where_awID = NA,
  where_awAnlageID = NA,
  where_awAnlageEigenschaftID = NA,
  where_awZahlwert = NA,
  where_awBeschreibung = NA,
  select = NULL,
  select_awID = NA,
  select_awAnlageID = NA,
  select_awAnlageEigenschaftID = NA,
  select_awZahlwert = NA,
  select_awBeschreibung = NA,
  orderBy = NULL,
  orderBy_awID = NA,
  orderBy_awAnlageID = NA,
  orderBy_awAnlageEigenschaftID = NA,
  orderBy_awZahlwert = NA,
  orderBy_awBeschreibung = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_awID

condition for field awID: Enter a field description here

where_awAnlageID

condition for field awAnlageID: Enter a field description here

where_awAnlageEigenschaftID

condition for field awAnlageEigenschaftID: Enter a field description here

where_awZahlwert

condition for field awZahlwert: Enter a field description here

where_awBeschreibung

condition for field awBeschreibung: Enter a field description here

select

fields/expressions to select

select_awID

select field awID?

select_awAnlageID

select field awAnlageID?

select_awAnlageEigenschaftID

select field awAnlageEigenschaftID?

select_awZahlwert

select field awZahlwert?

select_awBeschreibung

select field awBeschreibung?

orderBy

ORDER BY clause of SQL expression

orderBy_awID

order by field awID?

orderBy_awAnlageID

order by field awAnlageID?

orderBy_awAnlageEigenschaftID

order by field awAnlageEigenschaftID?

orderBy_awZahlwert

order by field awZahlwert?

orderBy_awBeschreibung

order by field awBeschreibung?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable