---
title: "SQL-016: clsXDeferredPrintCollection.UpdateSQL (dead code)"
summary: Updates deferred print items by document description — not wired to any live lifecycle method.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Services.Printing.Remote
reference_type: package
---

# SQL-016: clsXDeferredPrintCollection.UpdateSQL (dead code)

This SQL property defines an `UPDATE XDEFERRED_PRINT` statement that would update rows matched by `DOCUMENT_DESCR` rather than by primary key. The `BeforeUpdate` 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-016 |
| **Operation type** | Update |
| **Execution method** | Inline (⚠️ not wired to live `BeforeUpdate` method — `BeforeUpdate` is fully commented out in this class) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsXDeferredPrintCollection` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` (commented out) |

## Parameters

No live `AddParm` calls exist — `BeforeUpdate` is fully commented out. Bind variables present in SQL text only:

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:CopiesCount` | Input | Decimal* | — | Copies count |
| `:CreateDate` | Input | Date* | — | Creation date |
| `:CreateUser` | Input | String* | 30 | Creating user |
| `:DocumentDescr` | Input | String* | 60 | Document description (used in both SET and WHERE clauses) |
| `:DuplexCode` | Input | String* | 5 | Duplex code |
| `:FileName` | Input | String* | 120 | File name |
| `:PrintedDate` | Input | Date* | — | Printed date |
| `:Sort0Value`–`:Sort9Value` | Input | String* ×10 | 120 each | Sort/grouping columns |
| `:XMLValueText` | Input | NCLOB* | — | XML payload |
| `:XdeferredSeqNum` | Input | Decimal* | — | Sequence number |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [XDEFERRED_PRINT](../database-tables.md#xdeferred_print) | UPDATE | `COPIES_COUNT`, `CREATE_DATE`, `CREATE_USER`, `DOCUMENT_DESCR`, `DUPLEX_CODE`, `FILE_NAME`, `PRINTED_DATE`, `SORT0_VALUE`–`SORT9_VALUE`, `XML_VALUE_TEXT`, `XDEFERRED_SEQ_NUM` |

## Sample SQL

```sql
Update XDEFERRED_PRINT Set
    COPIES_COUNT    = :CopiesCount,
    CREATE_DATE     = :CreateDate,
    CREATE_USER     = :CreateUser,
    DOCUMENT_DESCR  = :DocumentDescr,
    DUPLEX_CODE     = :DuplexCode,
    FILE_NAME       = :FileName,
    PRINTED_DATE    = :PrintedDate,
    SORT0_VALUE     = :Sort0Value,
    SORT1_VALUE     = :Sort1Value,
    SORT2_VALUE     = :Sort2Value,
    SORT3_VALUE     = :Sort3Value,
    SORT4_VALUE     = :Sort4Value,
    SORT5_VALUE     = :Sort5Value,
    SORT6_VALUE     = :Sort6Value,
    SORT7_VALUE     = :Sort7Value,
    SORT8_VALUE     = :Sort8Value,
    SORT9_VALUE     = :Sort9Value,
    XML_VALUE_TEXT  = :XMLValueText,
    XDEFERRED_SEQ_NUM = :XdeferredSeqNum
Where
    XDEFERRED_PRINT.DOCUMENT_DESCR = :DocumentDescr
-- ⚠️ Not invoked — BeforeUpdate 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`