BBC.SHARED.VARA@SEC_SQLI.LIST-CALE-KEYWORDS
Summary
- %BBS_CALENDAR_I#
- Name of the calendar object whose keywords should be listed
- Object type
- VARA
- Object Folder
- PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING
- Title
- Retrieves list of keywords of one calendar object
- Archive Key 1
- -
- Archive Key 2
- -
- Created
- WRITER/B4A am: 2024-01-09 09:46:07
- Last Modified
- WRITER/B4A am: 2024-01-09 09:57:41 3 x
- Last Used
- -
SQL
- Statement (MS SQL)
- SELECT OKB_Name
FROM OH
JOIN OKB ON OH_IdNr = OKB_OH_IdNr
WHERE OH_OType = ‘CALE’
AND OH_Client = ?
AND OH_Name = ?
AND OH_DeleteFlag = 0
- Statement (Oracle)
- SELECT OKB_Name
FROM OH
JOIN OKB ON OH_IdNr = OKB_OH_IdNr
WHERE OH_OType = ‘CALE’
AND OH_Client = ?
AND OH_Name = ?
AND OH_DeleteFlag = 0
- Result Format
Bind Parameters
| Number |
Parameter |
| 1 |
&$CLIENT# |
| 2 |
|
Attributes
- Data Type
- TEXT
- Force Upper Case
- ❌
Script Access
- If key not found
- INITIAL_VALUES