SQL-007: Insert a new user favorite¶

This statement is the InsertSQL implementation of clsMenuFavorite.Criteria, executed from BeforeInsert against MENU_FAVORITE. Insert a new user favorite.

Classification¶

Field	Value
SQL ID	SQL-007
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	Sequence-assigned primary key (from SQL-001)
`:UserID`	Input	String	30	Owning menu user
`:UserEmplID`	Input	String	11	Owning user's employee ID
`:MenuItemSeqNum`	Input	Decimal	N/A	Favorited menu item
`:MenuOrder`	Input	Decimal	N/A	Display order among the user's favorites

Tables¶

Table	Access	Columns used
MENU_FAVORITE	INSERT	MENU_FAVORITE_SEQ_NUM, MENU_USER, MENU_USER_EMPLID, MENU_ITEM_SEQ_NUM, MENU_ORDER_NUM

Sample SQL¶

-- Insert a new user favorite
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¶

Create a menu item

Business rules¶

BR-MENU-020: Single-row write verification

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

Sources¶

SAIF.Business.Menu/clsMenuFavorite.vb