SQL-021: clsXDocumentCollection.DeleteSQL¶
Deletes all XDOCUMENT rows belonging to a given XPRINT_CONTROL_SEQ_NUM. This SQL is defined in clsXDocumentCollection.Criteria.DeleteSQL. However, no BeforeDelete override exists anywhere in clsXDocumentCollection — execution, if any, depends on undocumented base-class (clsBusinessCollectionBase) default wiring that could not be verified from this library's source.** AfterDelete is present and does check RowsAffected <> 1 per BR-001.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-021 |
| Operation type | Delete |
| Execution method | Inline (⚠️ no BeforeDelete override exists in clsXDocumentCollection; execution wiring is unverifiable from this library's source)** |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsXDocumentCollection |
| Criteria property | DeleteSQL |
| Lifecycle method | BeforeDelete (not overridden in this library) |
Parameters¶
No BeforeDelete override exists to confirm live parameter binding. Bind variable in SQL text:
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:XPrintControlSeqNum |
Input | Decimal* | — | Primary key of the XPRINT_CONTROL batch whose documents are to be deleted (type inferred from sibling usages) |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| XDOCUMENT | DELETE | XPRINT_CONTROL_SEQ_NUM |
Sample SQL¶
Delete XDOCUMENT
Where
XDOCUMENT.XPRINT_CONTROL_SEQ_NUM = :XPrintControlSeqNum
-- ⚠️ No BeforeDelete override exists in clsXDocumentCollection.vb.
-- Execution wiring is unverifiable from this library's source.
Operations and processes¶
Business rules¶
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\clsXDocumentCollection.vb