SQL-039: clsImageAffiliation¶

This statement deletes a single IMAGE_AFFILIATION row by IMAGE_AFFILIATION_SEQ_NUM. No live row-count contention check was found in this pass; the commented-out logic was excluded from live analysis.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ImageAffiliationSeqNum`	Input	[not specified]**	N/A	Primary key of the IMAGE_AFFILIATION row to delete.

Tables¶

Table	Access	Columns used
IMAGE_AFFILIATION	DELETE	IMAGE_AFFILIATION_SEQ_NUM

Sample SQL¶

Delete IMAGE_AFFILIATION
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