select and filter records from tblperson
kuras_person( where = NULL, where_pnID = NA, where_pnInitialien = NA, where_pnVorname = NA, where_pnNachname = NA, where_pnInstitutionID = NA, where_pnAdresse = NA, where_pnTelefon = NA, select = NULL, select_pnID = NA, select_pnInitialien = NA, select_pnVorname = NA, select_pnNachname = NA, select_pnInstitutionID = NA, select_pnAdresse = NA, select_pnTelefon = NA, orderBy = NULL, orderBy_pnID = NA, orderBy_pnInitialien = NA, orderBy_pnVorname = NA, orderBy_pnNachname = NA, orderBy_pnInstitutionID = NA, orderBy_pnAdresse = NA, orderBy_pnTelefon = NA, db = "KURAS", ... )
| where | WHERE condition |
|---|---|
| where_pnID | condition for field pnID: Enter a field description here |
| where_pnInitialien | condition for field pnInitialien: Enter a field description here |
| where_pnVorname | condition for field pnVorname: Enter a field description here |
| where_pnNachname | condition for field pnNachname: Enter a field description here |
| where_pnInstitutionID | condition for field pnInstitutionID: Enter a field description here |
| where_pnAdresse | condition for field pnAdresse: Enter a field description here |
| where_pnTelefon | condition for field pnTelefon: Enter a field description here |
| select | fields/expressions to |
| select_pnID |
|
| select_pnInitialien |
|
| select_pnVorname |
|
| select_pnNachname |
|
| select_pnInstitutionID |
|
| select_pnAdresse |
|
| select_pnTelefon |
|
| orderBy | ORDER BY clause of SQL expression |
| orderBy_pnID | order by field pnID? |
| orderBy_pnInitialien | order by field pnInitialien? |
| orderBy_pnVorname | order by field pnVorname? |
| orderBy_pnNachname | order by field pnNachname? |
| orderBy_pnInstitutionID | order by field pnInstitutionID? |
| orderBy_pnAdresse | order by field pnAdresse? |
| orderBy_pnTelefon | order by field pnTelefon? |
| db | name of ODBC data source, default: |
| ... | additional arguments passed to |