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