SQL-033: clsImageAffiliation¶

This statement updates an existing IMAGE_AFFILIATION row. No live row-count contention check was found in this pass; the commented-out row-count logic was excluded from live analysis.

Classification¶

Field	Value
SQL ID	SQL-033
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text**
Business object	`clsImageAffiliation`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:AffiliationImageSeqNum`	Input	[not specified]**	N/A	New affiliation image sequence number.
`:CreateUser`	Input	[not specified]**	30	User ID of the updater.
`:ImageSeqNum`	Input	[not specified]**	N/A	New image sequence number.
`:ImageAffiliationSeqNum`	Input	[not specified]**	N/A	Primary key of the row to update (WHERE clause).

Tables¶

Table	Access	Columns used
IMAGE_AFFILIATION	UPDATE	AFFILIATION_IMAGE_SEQ_NUM, CREATE_DATE, CREATE_USER, IMAGE_SEQ_NUM (WHERE: IMAGE_AFFILIATION_SEQ_NUM)

Sample SQL¶

Update IMAGE_AFFILIATION
Set
    AFFILIATION_IMAGE_SEQ_NUM = :AffiliationImageSeqNum,
    CREATE_DATE = sysdate,
    CREATE_USER = :CreateUser,
    IMAGE_SEQ_NUM = :ImageSeqNum
Where IMAGE_AFFILIATION.IMAGE_AFFILIATION_SEQ_NUM = :ImageAffiliationSeqNum

Operations and processes¶

Image affiliation

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

Sources¶

Business\SAIF.Business.Imaging\clsImageAffiliation.vb