SQL-027: Retrieve IMAGE_FILE_EXT_VIEW_UPDATE row¶

This statement retrieves a single IMAGE_FILE_EXT_VIEW_UPDATE row filtered by IMAGE_FILE_KEY and IMAGE_FILE_CODE. Executed by clsImageFileExternalViewUpdate.BeforeRetrieve.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ImageFileCode`	Input	[not specified]**	5	The image file code.
`:ImageFileKey`	Input	[not specified]**	5	The image file key.

Tables¶

Table	Access	Columns used
IMAGE_FILE_EXT_VIEW_UPDATE	SELECT	IMAGE_FILE_CODE, IMAGE_FILE_KEY, EXTERNAL_VIEW_DATE, UPDATE_NUM, UPDATE_USER, UPDATE_DATE, CREATE_USER, CREATE_DATE

Sample SQL¶

Select
    c.IMAGE_FILE_CODE as ImageFileCode,
    c.IMAGE_FILE_KEY as ImageFileKey,
    c.EXTERNAL_VIEW_DATE as ExternalViewDate,
    c.UPDATE_NUM as UpdateNum,
    c.UPDATE_USER as UpdateUser,
    c.UPDATE_DATE as UpdateDate,
    c.CREATE_USER as CreateUser,
    c.CREATE_DATE as CreateDate
From IMAGE_FILE_EXT_VIEW_UPDATE c
where IMAGE_FILE_KEY = :ImageFileKey
  and IMAGE_FILE_CODE = :ImageFileCode

Operations and processes¶

External view update tracking

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

Sources¶

Business\SAIF.Business.Imaging\clsImageFileExternalViewUpdate.vb