select
and filter records from tblprojekt
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", ... )
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_pID |
|
select_pName |
|
select_pBeginn |
|
select_pEnde |
|
select_pDurchfuehrungInstitutionID |
|
select_pAuftraggeberInstitutionID |
|
select_pBeschreibung |
|
select_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: |
... | additional arguments passed to |