SQL-005: Insert IMAGE_DOCUMENT_NAME_CODE row¶

This statement inserts a new row into IMAGE_DOCUMENT_NAME_CODE, creating a document name code entry that cross-references a file type, category, and document type. AfterInsert verifies exactly one row was affected.

Classification¶

Field	Value
SQL ID	SQL-005
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text**
Business object	`clsImageDocumentNameCode`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	[not specified]**	5	The document name code value.
`:CodeDescr`	Input	[not specified]**	65	Human-readable description of the code.
`:InternalDescr`	Input	[not specified]**	256	Internal description.
`:ImageFileCode`	Input	[not specified]**	5	The associated image file code.
`:ImageCategoryCode`	Input	[not specified]**	5	The associated image category code.
`:ImageDocumentTypeCode`	Input	[not specified]**	5	The associated image document type code.

Tables¶

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

Sample SQL¶

Insert into IMAGE_DOCUMENT_NAME_CODE (
    CODE,
    CODE_DESCR,
    INTERNAL_DESCR,
    IMAGE_FILE_CODE,
    IMAGE_CATEGORY_CODE,
    IMAGE_DOCUMENT_TYPE_CODE
) Values (
    :Code,
    :CodeDescr,
    :InternalDescr,
    :ImageFileCode,
    :ImageCategoryCode,
    :ImageDocumentTypeCode
)

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