BBC.SHARED.VARA@SEC_SQLI.GET-PROMPTSETS-OF-OBJECT
Summary
- Object type
- VARA
- Object Folder
- PACKAGES/BEST-BLU/BBC.SHARED/SOURCE
- Title
- get all values of assigned PromptSets
- Archive Key 1
- -
- Archive Key 2
- -
- Created
- WRITER/B4A am: 2022-06-30 13:49:02
- Last Modified
- WRITER/B4A am: 2022-07-01 19:11:50 4 x
- Last Used
- -
SQL
- Statement (MS SQL)
- SELECT OPU.OPU_Name from OPU
INNER JOIN OH ON OPU_OH_Idnr = OH.OH_Idnr
WHERE OH.OH_Name = ?
AND OH.OH_Client = ?
- Statement (Oracle)
- SELECT OPU.OPU_Name from OPU
INNER JOIN OH ON OPU_OH_Idnr = OH.OH_Idnr
WHERE OH.OH_Name = ?
AND OH.OH_Client = ?
- Result Format
Bind Parameters
| Number |
Parameter |
| 1 |
&$NAME# |
| 2 |
&$CLIENT# |
Attributes
- Data Type
- TEXT
- Force Upper Case
-
Script Access
- If key not found
- INITIAL_VALUES