SQL-026: Retrieve all IMAGE_FILE_CODE rows¶

This statement retrieves all rows from IMAGE_FILE_CODE with no filter criteria, ordered by CODE. Executed by clsImageFileCodeCollection.BeforeRetrieve to populate the full file-code collection.

Classification¶

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

Parameters¶

No parameters.

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
ORDER BY 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\clsImageFileCodeCollection.vb