SQL-035: Update a menu page¶

This statement is the UpdateSQL implementation of clsMenuPage.Criteria, executed from BeforeUpdate against MENU_PAGE. Update a menu page.

Classification¶

Field	Value
SQL ID	SQL-035
Operation type	Update
Execution method	StringBuilder-assembled
Database	Oracle
Schema	`[unqualified]`**
Command type	Text
Business object	`clsMenuPage`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PageName`	Input	String	100	Page link text
`:FavoriteName`	Input	String	100	Favorite-specific display name
`:PageLink`	Input	String	1000	Page URL
`:ApplicationCode`	Input	String	5	Owning application code
`:SavePreferencesFlag`	Input	String	1	Show save-preferences toolbar action (`Y`/`N`)
`:PrintFlag`	Input	String	1	Show print toolbar action (`Y`/`N`)
`:DownloadFlag`	Input	String	1	Show download toolbar action (`Y`/`N`)
`:HelpFlag`	Input	String	1	Show help toolbar action (`Y`/`N`)
`:SaveFlag`	Input	String	1	Show save toolbar action (`Y`/`N`)
`:InsertFlag`	Input	String	1	Show insert toolbar action (`Y`/`N`)
`:DeleteFlag`	Input	String	1	Show delete toolbar action (`Y`/`N`)
`:PrintTip`	Input	String	1000	Print action tooltip
`:DownloadTip`	Input	String	1000	Download action tooltip
`:SaveTip`	Input	String	1000	Save action tooltip
`:InsertTip`	Input	String	1000	Insert action tooltip
`:DeleteTip`	Input	String	1000	Delete action tooltip
`:UserId`	Input	String	30	Acting user, trimmed and upper-cased, stamped as `UPDATE_USER`
`:MenuPageSeqNum`	Input	Decimal	N/A	Page key

Tables¶

Table	Access	Columns used
MENU_PAGE	UPDATE	PAGE_NAME, FAVORITE_NAME, PAGE_LINK_TXT, APPLICATION_CODE, toolbar _FLAG / _TIP_TXT columns, UPDATE_DATE, UPDATE_USER (SET); MENU_PAGE_SEQ_NUM (WHERE)

Sample SQL¶

-- Update a menu page
UPDATE
  MENU_PAGE
Set
  PAGE_NAME = :PageName,
  FAVORITE_NAME = :FavoriteName,
  PAGE_LINK_TXT = :PageLink,
  APPLICATION_CODE = :ApplicationCode,
  SAVE_PREFERENCES_FLAG = :SavePreferencesFlag,
  PRINT_FLAG = :PrintFlag,
  DOWNLOAD_FLAG = :DownloadFlag,
  HELP_FLAG = :HelpFlag,
  SAVE_FLAG = :SaveFlag,
  INSERT_FLAG = :InsertFlag,
  DELETE_FLAG = :DeleteFlag,
  PRINT_TIP_TXT = :PrintTip,
  DOWNLOAD_TIP_TXT = :DownloadTip,
  SAVE_TOOLTIP_TXT = :SaveTip,
  INSERT_TOOLTIP_TXT = :InsertTip,
  DELETE_TOOLTIP_TXT = :DeleteTip,
  UPDATE_DATE = SYSDATE,
  UPDATE_USER = :UserId
WHERE
  MENU_PAGE.MENU_PAGE_SEQ_NUM = :MenuPageSeqNum

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/clsMenuPage.vb