BBC.SHARED.VARA@SEC_SQLI.GET-SYSTEM-SETTING
Details
| Property | Value |
|---|---|
| Type | VARA |
| 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-13 18:34:22 |
| Last Modified | WRITER/B4A am: 2022-06-13 18:34:22 1 x |
| Last Used | - |
SQL
- Statement (MS SQL)
- SELECT OVW.OVW_VValue AS Key, OVW.OVW_Value1 AS Value1 FROM OVWJOIN OH ON OVW_OH_Idnr = OH.OH_IdnrWHERE 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 OVWJOIN OH ON OVW_OH_Idnr = OH.OH_IdnrWHERE 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