SQL-043: clsImageIdx¶
The DeleteSQL property of clsImageIdx defines a DELETE statement for the IMAGE table. However, clsImageIdx does not implement a live BeforeDelete or AfterDelete method in the analysed source, so this statement is not executed through the standard BOF lifecycle. The delete path for IMAGE records appears non-functional in current live code**.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-043 |
| Operation type | Delete |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text** |
| Business object | clsImageIdx |
| Criteria property | DeleteSQL |
| Lifecycle method | [no live BeforeDelete method]** |
Parameters¶
No AddParm calls are paired with this statement; no live BeforeDelete method exists**.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| IMAGE | DELETE | IMAGE_SEQ_NUM |
Sample SQL¶
-- Note: No live BeforeDelete/AfterDelete pair found for clsImageIdx**
Delete IMAGE
Where IMAGE.IMAGE_SEQ_NUM = :ImageSeqNum
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Imaging\clsImageIdx.vb