---
title: "SQL-034: clsImageDocumentNameCode"
summary: Update statement for clsImageDocumentNameCode.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.Imaging
reference_type: package
---

# SQL-034: clsImageDocumentNameCode

This statement updates `IMAGE_DOCUMENT_NAME_CODE` columns. However, the `UpdateSQL` property ends with a bare `Where` keyword without any predicate, suggesting this update path is incomplete or dead code**. `AfterUpdate` verifies exactly one row affected.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-034 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text** |
| **Business object** | `clsImageDocumentNameCode` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:Code` | Input | [not specified]** | 5 | The document name code. |
| `:CodeDescr` | Input | [not specified]** | 65 | Code description. |
| `:InternalDescr` | Input | [not specified]** | 256 | Internal description. |
| `:ImageFileCode` | Input | [not specified]** | 5 | Image file code. |
| `:ImageCategoryCode` | Input | [not specified]** | 5 | Image category code. |
| `:ImageDocumentTypeCode` | Input | [not specified]** | 5 | Image document type code. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [IMAGE_DOCUMENT_NAME_CODE](../database-tables.md#image_document_name_code) | UPDATE | CODE, CODE_DESCR, INTERNAL_DESCR, IMAGE_FILE_CODE, IMAGE_CATEGORY_CODE, IMAGE_DOCUMENT_TYPE_CODE |

## Sample SQL

```sql
-- Note: SQL ends with bare WHERE — likely an incomplete implementation**
Update IMAGE_DOCUMENT_NAME_CODE
Set
    CODE = :Code,
    CODE_DESCR = :CodeDescr,
    INTERNAL_DESCR = :InternalDescr,
    IMAGE_FILE_CODE = :ImageFileCode,
    IMAGE_CATEGORY_CODE = :ImageCategoryCode,
    IMAGE_DOCUMENT_TYPE_CODE = :ImageDocumentTypeCode
Where
```

## Operations and processes
- [Code table management](../operations/code-table-management.md)

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

## Sources
- `Business\SAIF.Business.Imaging\clsImageDocumentNameCode.vb`