---
title: "SQL-019: clsXDeferredPrint.DeleteSQL"
summary: Deletes a single deferred print item by primary key.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Services.Printing.Remote
reference_type: package
---

# SQL-019: clsXDeferredPrint.DeleteSQL

Deletes a single row from `XDEFERRED_PRINT` by its primary key (`XDEFERRED_SEQ_NUM`). This is the live delete path for `clsXDeferredPrint.BeforeDelete`. Note: `AfterDelete` for this class has its row-count contention check commented out — no live post-delete validation applies for this specific delete.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-019 |
| **Operation type** | Delete |
| **Execution method** | Inline |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsXDeferredPrint` |
| **Criteria property** | `DeleteSQL` |
| **Lifecycle method** | `BeforeDelete` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:XdeferredSeqNum` | Input | Decimal | — | Primary key of the row to delete |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [XDEFERRED_PRINT](../database-tables.md#xdeferred_print) | DELETE | `XDEFERRED_SEQ_NUM` |

## Sample SQL

```sql
Delete XDEFERRED_PRINT
Where
    XDEFERRED_PRINT.XDEFERRED_SEQ_NUM = :XdeferredSeqNum
```

## Operations and processes
- [Deferred print queue lifecycle](../operations/deferred-print-queue-lifecycle.md)

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

## Sources
- `Services\SAIF.Services.Printing.Remote\clsXDeferredPrint.vb`