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

# SQL-040: clsImageDocumentNameCode

This statement deletes from `IMAGE_DOCUMENT_NAME_CODE`. The `DeleteSQL` property ends with a bare `Where` keyword and `BeforeDelete` adds no parameters, so no row can be identified and this path appears to be incomplete or dead code**. `AfterDelete` verifies exactly one row affected.

## Classification

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

## Parameters

No `AddParm` calls are paired with this statement. No key parameters are bound**.

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [IMAGE_DOCUMENT_NAME_CODE](../database-tables.md#image_document_name_code) | DELETE | (WHERE predicate incomplete)** |

## Sample SQL

```sql
-- Note: SQL ends with bare WHERE — likely dead/incomplete code**
Delete from IMAGE_DOCUMENT_NAME_CODE
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`