SQL-018: Retrieve all menu category codes¶
This statement is the RetrieveSQL implementation of clsMenuCategoryCodeCollection.Criteria, executed from BeforeRetrieve against MENU_CATEGORY_CODE. Retrieve all menu category codes.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-018 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsMenuCategoryCodeCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
This statement takes no bind parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| MENU_CATEGORY_CODE | SELECT | CODE, CODE_DESCR |
Sample SQL¶
-- Retrieve all menu category codes
Select
MENU_CATEGORY_CODE.CODE as Code,
MENU_CATEGORY_CODE.CODE_DESCR as CodeDescr
From
MENU_CATEGORY_CODE
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
- SAIF.Business.Menu/clsMenuCategoryCodeCollection.vb