BBC.SHARED.VARA@SEC_SQLI.GET-SYSTEM-SETTING

Summary

Object type
VARA
Object Folder
PACKAGES/BEST-BLU/BBC.SHARED/SOURCE
Title
Read access to UC_SYSTEM_SETTINGS
Archive Key 1
-
Archive Key 2
-
Created
WRITER/B4A am: 2022-06-30 13:11:45
Last Modified
WRITER/B4A am: 2024-01-09 09:57:42 9 x
Last Used
-

SQL

Statement (MS SQL)
SELECT OVW.OVW_VValue AS Key, OVW.OVW_Value1 AS Value1 FROM OVW JOIN OH ON OVW_OH_Idnr = OH.OH_Idnr WHERE OH.OH_Name = ‘UC_SYSTEM_SETTINGS’ AND OH.OH_Client = 0
Statement (Oracle)
SELECT OVW.OVW_VValue AS Key, OVW.OVW_Value1 AS Value1 FROM OVW JOIN OH ON OVW_OH_Idnr = OH.OH_Idnr WHERE OH.OH_Name = ‘UC_SYSTEM_SETTINGS’ AND OH.OH_Client = 0
Result Format

Bind Parameters

Attributes

Data & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES