SQL-025: Retrieve IMAGE_FILE_CODE by code¶

This statement retrieves a single IMAGE_FILE_CODE row by CODE. Executed by clsImageFileCode.BeforeRetrieve.

Classification¶

Field	Value
SQL ID	SQL-025
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text**
Business object	`clsImageFileCode`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	[not specified]**	5	The image file code to retrieve.

Tables¶

Table	Access	Columns used
IMAGE_FILE_CODE	SELECT	CODE, CODE_DESCR, CREATE_DATE, CREATE_USER

Sample SQL¶

Select
    IMAGE_FILE_CODE.CODE as Code,
    IMAGE_FILE_CODE.CODE_DESCR as CodeDescr,
    IMAGE_FILE_CODE.CREATE_DATE as CreateDate,
    IMAGE_FILE_CODE.CREATE_USER as CreateUser
From IMAGE_FILE_CODE
Where IMAGE_FILE_CODE.CODE = :Code

Operations and processes¶

Code table management

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

Sources¶

Business\SAIF.Business.Imaging\clsImageFileCode.vb