SQL-MENU-038: Insert menu favorite¶

Insert a menu favorite row.

Classification¶

Field	Value
SQL ID	SQL-MENU-038
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsMenuFavorite`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:MenuFavoriteSeqNum`	Input	Decimal	N/A	Favorite-row key.
`:UserID`	Input	String	30	Favorite owner login.
`:UserEmplID`	Input	String	11	Favorite owner employee id.
`:MenuItemSeqNum`	Input	Decimal	N/A	Menu item key.
`:MenuOrder`	Input	Decimal	N/A	Favorite display order.

Tables¶

Table	Access	Columns used
MENU_FAVORITE	INSERT	`MENU_FAVORITE_SEQ_NUM`, `MENU_USER`, `MENU_ITEM_SEQ_NUM`, `MENU_ORDER_NUM`, `ITEM_INACTIVE_DATE`

Sample SQL¶

INSERT INTO MENU_FAVORITE (
  MENU_FAVORITE_SEQ_NUM,
  MENU_USER,
  MENU_USER_EMPLID,
  MENU_ITEM_SEQ_NUM,
  MENU_ORDER_NUM)
VALUES (
  :MenuFavoriteSeqNum,
  :UserID,
  :UserEmplID,
  :MenuItemSeqNum,
  :MenuOrder)

Operations and processes¶

Manage a user's menu favorites

Business rules¶

BR-MENU-001: Optimistic contention on write

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

Sources¶

SAIF.Business.Menu\clsMenuFavorite.vb