---
title: "SQL-018: clsXPrintControlCollection.UpdateSQL (dead code)"
summary: Updates a print-control batch header — 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-018: clsXPrintControlCollection.UpdateSQL (dead code)

This SQL property defines an `UPDATE XPRINT_CONTROL` statement at the collection level. The `BeforeUpdate` method in `clsXPrintControlCollection` is fully commented out, so this SQL is never executed. No live `AddParm` calls exist for this property.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-018 |
| **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** | `clsXPrintControlCollection` |
| **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 (`:XprintControlSeqNum` appears twice — once in SET, once in WHERE):

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:DirectoryName` | Input | String* | 120 | Output directory |
| `:DuplexCode` | Input | String* | 5 | Duplex code |
| `:IdmPathName` | Input | String* | 30 | IDM path name |
| `:Md5HashValue` | Input | String* | 40 | MD5 hash |
| `:ProcessedDate` | Input | Date* | — | Processed date |
| `:XmlFileName` | Input | String* | 120 | XML file name |
| `:XprintControlSeqNum` | Input | Decimal* | — | Primary key (SET clause and WHERE clause — appears twice) |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [XPRINT_CONTROL](../database-tables.md#xprint_control) | UPDATE | `DIRECTORY_NAME`, `DUPLEX_CODE`, `IDM_PATH_NAME`, `MD5_HASH_VALUE`, `PROCESSED_DATE`, `XML_FILE_NAME`, `XPRINT_CONTROL_SEQ_NUM` |

## Sample SQL

```sql
Update XPRINT_CONTROL Set
    DIRECTORY_NAME          = :DirectoryName,
    DUPLEX_CODE             = :DuplexCode,
    IDM_PATH_NAME           = :IdmPathName,
    MD5_HASH_VALUE          = :Md5HashValue,
    PROCESSED_DATE          = :ProcessedDate,
    XML_FILE_NAME           = :XmlFileName,
    XPRINT_CONTROL_SEQ_NUM  = :XprintControlSeqNum
Where
    XPRINT_CONTROL.XPRINT_CONTROL_SEQ_NUM = :XprintControlSeqNum
-- ⚠️ 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\clsXPrintControlCollection.vb`