SQL-041: clsImageFileExternalViewUpdate¶
This statement deletes from IMAGE_FILE_EXT_VIEW_UPDATE using IMAGE_FILE_KEY and IMAGE_FILE_CODE in the WHERE clause. However, the live BeforeDelete method does not call AddParm for these parameters, making this path appear incomplete**. AfterDelete verifies exactly one row affected.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-041 |
| Operation type | Delete |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text** |
| Business object | clsImageFileExternalViewUpdate |
| Criteria property | DeleteSQL |
| Lifecycle method | BeforeDelete |
Parameters¶
No AddParm calls are paired with this statement in the live BeforeDelete method; the :ImageFileKey and :ImageFileCode bind variables are not bound at runtime**.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| IMAGE_FILE_EXT_VIEW_UPDATE | DELETE | IMAGE_FILE_KEY, IMAGE_FILE_CODE |
Sample SQL¶
-- Note: BeforeDelete does not bind :ImageFileKey or :ImageFileCode**
Delete from IMAGE_FILE_EXT_VIEW_UPDATE
where IMAGE_FILE_KEY = :ImageFileKey
and IMAGE_FILE_CODE = :ImageFileCode
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Imaging\clsImageFileExternalViewUpdate.vb