BBC.SHARED.VARA@SEC_SQLI.GET-OBJECT-SUBTYPE
Summary
Description
Retrieves the sub-type of a given object
Input
- &BBCS_OBJECT_I#
- name of the object for which the sub-type should be retrieved
- Object type
- VARA
- Object Folder
- PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/DATA
- Title
- Retrieves the sub-type of an object
- Archive Key 1
- -
- Archive Key 2
- -
- Created
- WRITER/B4A am: 2024-01-09 09:46:07
- Last Modified
- WRITER/B4A am: 2024-01-09 09:57:41 3 x
- Last Used
- -
SQL
- Statement (MS SQL)
- SELECT OH_Name “Name”, OH_OType As “Type”, OH_SubType AS “Sub Type” FROM OH WHERE OH_Client = ? AND OH_Name = ? AND OH_DeleteFlag = 0
- Statement (Oracle)
- SELECT OH_Name “Name”, OH_OType As “Type”, OH_SubType AS “Sub Type” FROM OH WHERE OH_Client = ? AND OH_Name = ? AND OH_DeleteFlag = 0
- Result Format
Bind Parameters
Number | Parameter |
---|---|
1 | &$CLIENT# |
2 | &BBCF_OBJECT_I# |
Attributes
Data & Formatting
- Data Type
- TEXT
- Force Upper Case
- ❌
Script Access
- If key not found
- INITIAL_VALUES