Update a menu page row.
Classification
| Field |
Value |
| SQL ID |
SQL-MENU-022 |
| 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 name. |
:FavoriteName |
Input |
String |
100 |
Favorite display name. |
:PageLink |
Input |
String |
1000 |
Page link text. |
:ApplicationCode |
Input |
String |
5 |
Application lookup code. |
:SavePreferencesFlag |
Input |
String |
1 |
Y/N page flag. |
:PrintFlag |
Input |
String |
1 |
Y/N page flag. |
:DownloadFlag |
Input |
String |
1 |
Y/N page flag. |
:HelpFlag |
Input |
String |
1 |
Y/N page flag. |
:SaveFlag |
Input |
String |
1 |
Y/N page flag. |
:InsertFlag |
Input |
String |
1 |
Y/N page flag. |
:DeleteFlag |
Input |
String |
1 |
Y/N page flag. |
:PrintTip |
Input |
String |
1000 |
Print tooltip. |
:DownloadTip |
Input |
String |
1000 |
Download tooltip. |
:SaveTip |
Input |
String |
1000 |
Save tooltip. |
:InsertTip |
Input |
String |
1000 |
Insert tooltip. |
:DeleteTip |
Input |
String |
1000 |
Delete tooltip. |
:UserId |
Input |
String |
30 |
Audit user. |
:MenuPageSeqNum |
Input |
Decimal |
N/A |
Menu page key. |
Tables
| Table |
Access |
Columns used |
| MENU_PAGE |
UPDATE |
MENU_PAGE_SEQ_NUM, PAGE_LINK_TXT, APPLICATION_CODE |
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
Business rules
Note: Statements marked with ** could not be confirmed; treat
as unknown until verified.
Sources
SAIF.Business.Menu\clsMenuPage.vb