---
title: "SQL-008: clsXPrintControlCollection.InsertSQL (dead code)"
summary: Inserts 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-008: clsXPrintControlCollection.InsertSQL (dead code)

This SQL property defines an `INSERT INTO XPRINT_CONTROL` statement at the collection level. The `BeforeInsert` 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-008 |
| **Operation type** | Create (Insert) |
| **Execution method** | Inline (⚠️ not wired to live `BeforeInsert` method — `BeforeInsert` is fully commented out in this class) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsXPrintControlCollection` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert` (commented out) |

## Parameters

No live `AddParm` calls exist — `BeforeInsert` is fully commented out. Bind variables present in SQL text only (types inferred from column names and sibling SQL-007):

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:DirectoryName` | Input | String* | 120 | Output directory for the print batch |
| `:DuplexCode` | Input | String* | 5 | Duplex printing code |
| `:IdmPathName` | Input | String* | 30 | IDM destination path |
| `:Md5HashValue` | Input | String* | 40 | MD5 hash |
| `:ProcessedDate` | Input | Date* | — | Processed date |
| `:XmlFileName` | Input | String* | 120 | XML file name |
| `:XprintControlSeqNum` | Input | Decimal* | — | Primary key |

## Tables

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

## Sample SQL

```sql
INSERT INTO XPRINT_CONTROL (
    DIRECTORY_NAME,
    DUPLEX_CODE,
    IDM_PATH_NAME,
    MD5_HASH_VALUE,
    PROCESSED_DATE,
    XML_FILE_NAME,
    XPRINT_CONTROL_SEQ_NUM
) VALUES (
    :DirectoryName,
    :DuplexCode,
    :IdmPathName,
    :Md5HashValue,
    :ProcessedDate,
    :XmlFileName,
    :XprintControlSeqNum
)
-- ⚠️ Not invoked — BeforeInsert 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`