SQL-034: Update a menu item

This statement is the UpdateSQL implementation of clsMenuItem.Criteria, executed from BeforeUpdate against MENU_ITEM. Update a menu item.

Classification

Field	Value
SQL ID	SQL-034
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMenuItem
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:MenuPageSeqNum	Input	Decimal	N/A	Page placed by this item
:MenuCategoryCode	Input	String	5	Owning category code
:ToolTip	Input	String	1000	Item tooltip text
:VisibleFlag	Input	String	1	Visibility as Y/N
:PageOrder	Input	Decimal	N/A	Display order within the category
:UserId	Input	String	30	Acting user, trimmed and upper-cased, stamped as UPDATE_USER
:MenuItemSeqNum	Input	Decimal	N/A	Menu item key

Tables

Table	Access	Columns used
MENU_ITEM	UPDATE	MENU_PAGE_SEQ_NUM, MENU_CATEGORY_CODE, TOOL_TIP_TXT, VISIBLE_FLAG, PAGE_ORDER_NUM, UPDATE_DATE, UPDATE_USER (SET); MENU_ITEM_SEQ_NUM (WHERE)

Sample SQL

-- Update a menu item
Update
  MENU_ITEM
Set
  MENU_PAGE_SEQ_NUM = :MenuPageSeqNum,
  MENU_CATEGORY_CODE = :MenuCategoryCode,
  TOOL_TIP_TXT = :ToolTip,
  VISIBLE_FLAG = :VisibleFlag,
  PAGE_ORDER_NUM = :PageOrder,
  UPDATE_DATE = SYSDATE,
  UPDATE_USER = :UserId
Where
  MENU_ITEM.MENU_ITEM_SEQ_NUM = :MenuItemSeqNum

Operations and processes

• Update or delete a maintained object

Business rules

• BR-MENU-016: Audit stamp on insert and update
• BR-MENU-019: Y/N boolean flag storage
• BR-MENU-020: Single-row write verification

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• SAIF.Business.Menu/clsMenuItem.vb