Skip to contents

select records from tblmassnahmetyp

Source: R/kurasDbInterface.R
kuras_massnahmetyp.Rd

select and filter records from tblmassnahmetyp

Usage

kuras_massnahmetyp(
  where = NULL,
  where_mID = NA,
  where_mName = NA,
  where_mBeschreibung = NA,
  where_mMassnahmenKategorieID = NA,
  select = NULL,
  select_mID = NA,
  select_mName = NA,
  select_mBeschreibung = NA,
  select_mMassnahmenKategorieID = NA,
  orderBy = NULL,
  orderBy_mID = NA,
  orderBy_mName = NA,
  orderBy_mBeschreibung = NA,
  orderBy_mMassnahmenKategorieID = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_mID

condition for field mID: Enter a field description here

where_mName

condition for field mName: Enter a field description here

where_mBeschreibung

condition for field mBeschreibung: Enter a field description here

where_mMassnahmenKategorieID

condition for field mMassnahmenKategorieID: Enter a field description here

select

fields/expressions to select

select_mID

select field mID?

select_mName

select field mName?

select_mBeschreibung

select field mBeschreibung?

select_mMassnahmenKategorieID

select field mMassnahmenKategorieID?

orderBy

ORDER BY clause of SQL expression

orderBy_mID

order by field mID?

orderBy_mName

order by field mName?

orderBy_mBeschreibung

order by field mBeschreibung?

orderBy_mMassnahmenKategorieID

order by field mMassnahmenKategorieID?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable