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 |