SQL-020: clsXDeferredPrintCollection.DeleteSQL (dead code)¶
This SQL property defines a DELETE XDEFERRED_PRINT statement filtered by DOCUMENT_DESCR. The BeforeDelete method in clsXDeferredPrintCollection is fully commented out, so this SQL is never executed. No live AddParm calls exist for this property.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-020 |
| Operation type | Delete |
| Execution method | Inline (⚠️ not wired to live BeforeDelete method — BeforeDelete is fully commented out in this class) |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsXDeferredPrintCollection |
| Criteria property | DeleteSQL |
| Lifecycle method | BeforeDelete (commented out) |
Parameters¶
No live AddParm calls exist — BeforeDelete is fully commented out. Bind variable present in SQL text only:
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:DocumentDescr |
Input | String* | 60 | Document description filter (type inferred from sibling usages) |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| XDEFERRED_PRINT | DELETE | DOCUMENT_DESCR |
Sample SQL¶
Delete XDEFERRED_PRINT
Where
XDEFERRED_PRINT.DOCUMENT_DESCR = :DocumentDescr
-- ⚠️ Not invoked — BeforeDelete in this class is fully commented out.
Note: Statements marked with
*were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with**could not be confirmed; treat as unknown until verified.
Sources¶
Services\SAIF.Services.Printing.Remote\clsXDeferredPrintCollection.vb