Zum Hauptinhalt springen

BBC.SHARED.VARA@SEC_SQLI.LIST-OBJECT-TEMPLATES

Details​

PropertyValue
TypeVARA
FolderPACKAGES/BEST-BLU/BBC.SHARED/SOURCE/LISTING
TitleReturns a list of object templates
Archive Key 1-
Archive Key 2-
CreatedAndreas Büsching am: 2020-09-15 11:31:45
Last ModifiedWRITER/B4A am: 2022-06-13 18:34:20 22 x
Last Used-

SQL​

Statement (MS SQL)
SELECT OVW_VValue AS "Name", OVW_Value1 AS "Object"FROM OHRIGHT OUTER JOIN OVW ON OH_IdNr = OVW_OH_IdNrWHERE OH_Name = 'UC_OBJECT_TEMPLATE'AND OH_Client = ?AND OH_DeleteFlag = 0
Statement (Oracle)
SELECT OVW_VValue AS "Name", OVW_Value1 AS "Object"FROM OHRIGHT OUTER JOIN OVW ON OH_IdNr = OVW_OH_IdNrWHERE OH_Name = 'UC_OBJECT_TEMPLATE'AND OH_Client = ?AND OH_DeleteFlag = 0

Result Format :

Bind Parameters​

NumberParameter
1&$CLIENT#

Attributes​

Data & Formatting​

Data Type
TEXT
Force Upper Case
❌

Script Access​

If key not found
INITIAL_VALUES