Skip to contents

select records from tblprojekt

Source: R/kurasDbInterface.R
kuras_projekt.Rd

select and filter records from tblprojekt

Usage

kuras_projekt(
  where = NULL,
  where_pID = NA,
  where_pName = NA,
  where_pBeginn = NA,
  where_pEnde = NA,
  where_pDurchfuehrungInstitutionID = NA,
  where_pAuftraggeberInstitutionID = NA,
  where_pBeschreibung = NA,
  where_pProjektblattnummer = NA,
  select = NULL,
  select_pID = NA,
  select_pName = NA,
  select_pBeginn = NA,
  select_pEnde = NA,
  select_pDurchfuehrungInstitutionID = NA,
  select_pAuftraggeberInstitutionID = NA,
  select_pBeschreibung = NA,
  select_pProjektblattnummer = NA,
  orderBy = NULL,
  orderBy_pID = NA,
  orderBy_pName = NA,
  orderBy_pBeginn = NA,
  orderBy_pEnde = NA,
  orderBy_pDurchfuehrungInstitutionID = NA,
  orderBy_pAuftraggeberInstitutionID = NA,
  orderBy_pBeschreibung = NA,
  orderBy_pProjektblattnummer = NA,
  db = "KURAS",
  ...
)

Arguments

where

WHERE condition

where_pID

condition for field pID: Enter a field description here

where_pName

condition for field pName: Enter a field description here

where_pBeginn

condition for field pBeginn: Enter a field description here

where_pEnde

condition for field pEnde: Enter a field description here

where_pDurchfuehrungInstitutionID

condition for field pDurchfuehrungInstitutionID: Enter a field description here

where_pAuftraggeberInstitutionID

condition for field pAuftraggeberInstitutionID: Enter a field description here

where_pBeschreibung

condition for field pBeschreibung: Enter a field description here

where_pProjektblattnummer

condition for field pProjektblattnummer: Enter a field description here

select

fields/expressions to select

select_pID

select field pID?

select_pName

select field pName?

select_pBeginn

select field pBeginn?

select_pEnde

select field pEnde?

select_pDurchfuehrungInstitutionID

select field pDurchfuehrungInstitutionID?

select_pAuftraggeberInstitutionID

select field pAuftraggeberInstitutionID?

select_pBeschreibung

select field pBeschreibung?

select_pProjektblattnummer

select field pProjektblattnummer?

orderBy

ORDER BY clause of SQL expression

orderBy_pID

order by field pID?

orderBy_pName

order by field pName?

orderBy_pBeginn

order by field pBeginn?

orderBy_pEnde

order by field pEnde?

orderBy_pDurchfuehrungInstitutionID

order by field pDurchfuehrungInstitutionID?

orderBy_pAuftraggeberInstitutionID

order by field pAuftraggeberInstitutionID?

orderBy_pBeschreibung

order by field pBeschreibung?

orderBy_pProjektblattnummer

order by field pProjektblattnummer?

db

name of ODBC data source, default: "KURAS"

...

additional arguments passed to kwb.db::selectFromTable