SQL-MENU-037: Delete menu favorite

Delete a menu favorite row.

Classification

Field	Value
SQL ID	SQL-MENU-037
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMenuFavorite
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
:MenuFavoriteSeqNum	Input	Decimal	N/A	Favorite-row key.

Tables

Table	Access	Columns used
MENU_FAVORITE	DELETE	MENU_FAVORITE_SEQ_NUM, MENU_USER, MENU_ITEM_SEQ_NUM, MENU_ORDER_NUM, ITEM_INACTIVE_DATE

Sample SQL

DELETE MENU_FAVORITE
WHERE MENU_FAVORITE.MENU_FAVORITE_SEQ_NUM = :MenuFavoriteSeqNum

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