SQL-035: clsMenuPage¶

Updates an existing menu page record in MENU_PAGE. The SQL is assembled via StringBuilder and includes 18 bound parameters. UPDATE_DATE is set to SYSDATE.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PageName`	Input	String**	100	Page display name bound from `PageName`.
`:FavoriteName`	Input	String**	100	Favorite label bound from `FavoriteName`.
`:PageLink`	Input	String**	1000	Page URL bound from `PageLink`.
`:ApplicationCode`	Input	String**	5	Application code bound from `ApplicationCode`.
`:SavePreferencesFlag`	Input	String**	1	Toolbar flag bound from `IsDisplaySavePreferences.ToY_N_String`.
`:PrintFlag`	Input	String**	1	Toolbar flag bound from `IsDisplayPrint.ToY_N_String`.
`:DownloadFlag`	Input	String**	1	Toolbar flag bound from `IsDisplayDownload.ToY_N_String`.
`:HelpFlag`	Input	String**	1	Toolbar flag bound from `IsDisplayHelp.ToY_N_String`.
`:SaveFlag`	Input	String**	1	Toolbar flag bound from `IsDisplaySave.ToY_N_String`.
`:InsertFlag`	Input	String**	1	Toolbar flag bound from `IsDisplayInsert.ToY_N_String`.
`:DeleteFlag`	Input	String**	1	Toolbar flag bound from `IsDisplayDelete.ToY_N_String`.
`:PrintTip`	Input	String**	1000	Print tooltip bound from `PrintToolTip`.
`:DownloadTip`	Input	String**	1000	Download tooltip bound from `DownloadToolTip`.
`:SaveTip`	Input	String**	1000	Save tooltip bound from `SaveToolTip`.
`:InsertTip`	Input	String**	1000	Insert tooltip bound from `InsertToolTip`.
`:DeleteTip`	Input	String**	1000	Delete tooltip bound from `DeleteToolTip`.
`:UserId`	Input	String**	30	Update user bound from `DataPortalInfo.UserID`.
`:MenuPageSeqNum`	Input	Decimal**	N/A	WHERE key bound from `MenuPageSeqNum`.

Tables¶

Table	Access	Columns used
MENU_PAGE	UPDATE	`PAGE_NAME`, `FAVORITE_NAME`, `PAGE_LINK_TXT`, `APPLICATION_CODE`, `SAVE_PREFERENCES_FLAG`, `PRINT_FLAG`, `DOWNLOAD_FLAG`, `HELP_FLAG`, `SAVE_FLAG`, `INSERT_FLAG`, `DELETE_FLAG`, `PRINT_TIP_TXT`, `DOWNLOAD_TIP_TXT`, `SAVE_TOOLTIP_TXT`, `INSERT_TOOLTIP_TXT`, `DELETE_TOOLTIP_TXT`, `UPDATE_DATE`, `UPDATE_USER` (WHERE `MENU_PAGE_SEQ_NUM`)

Sample SQL¶

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¶

Menu tree construction

Business rules¶

BR-MNU-02: DML row-count enforcement

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Menu\clsMenuPage.vb