SQL-029: Help-text retrieval¶
This document describes SQL-029, the help-text retrieval statement or call used by SAIF.Business.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-029 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsHelpText |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
This SQL statement has no explicit parameters in the provided findings.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| APPLICATION_HELP_DETAIL | SELECT | See sample SQL and source implementation. |
Sample SQL¶
SELECT APPLICATION_HELP_DETAIL.REFERENCE_KEY_VALUE AS Key,
APPLICATION_HELP_DETAIL.HELP_TEXT AS HelpText
FROM APPLICATION_HELP_DETAIL
WHERE reference_key_value = :Key
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business\clsHelpText.vb