SQL-034: clsImageDocumentNameCode¶

This statement updates IMAGE_DOCUMENT_NAME_CODE columns. However, the UpdateSQL property ends with a bare Where keyword without any predicate, suggesting this update path is incomplete or dead code**. AfterUpdate verifies exactly one row affected.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	[not specified]**	5	The document name code.
`:CodeDescr`	Input	[not specified]**	65	Code description.
`:InternalDescr`	Input	[not specified]**	256	Internal description.
`:ImageFileCode`	Input	[not specified]**	5	Image file code.
`:ImageCategoryCode`	Input	[not specified]**	5	Image category code.
`:ImageDocumentTypeCode`	Input	[not specified]**	5	Image document type code.

Tables¶

Table	Access	Columns used
IMAGE_DOCUMENT_NAME_CODE	UPDATE	CODE, CODE_DESCR, INTERNAL_DESCR, IMAGE_FILE_CODE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE

Sample SQL¶

-- Note: SQL ends with bare WHERE — likely an incomplete implementation**
Update IMAGE_DOCUMENT_NAME_CODE
Set
    CODE = :Code,
    CODE_DESCR = :CodeDescr,
    INTERNAL_DESCR = :InternalDescr,
    IMAGE_FILE_CODE = :ImageFileCode,
    IMAGE_CATEGORY_CODE = :ImageCategoryCode,
    IMAGE_DOCUMENT_TYPE_CODE = :ImageDocumentTypeCode
Where

Operations and processes¶

Code table management

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

Sources¶

Business\SAIF.Business.Imaging\clsImageDocumentNameCode.vb