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:11:42
Last Modified
WRITER/B4A am: 2024-01-09 09:57:39 9 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 & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES