---
title: SAIF.Application.LogView SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-24
library: SAIF.Application.LogView
reference_type: package
---

# SAIF.Application.LogView SQL catalog

This page indexes all SQL statements used by this library, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-003](SQL-003-saif-application-logview.md) | `clsAppError.InsertSQL` — insert an application error log row | Inline | `App_Error` | `clsAppError` |
| [SQL-004](SQL-004-saif-application-logview.md) | `clsAppInfo.InsertSQL` — insert an application info/audit log row | Inline | `App_Info` | `clsAppInfo` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](SQL-005-saif-application-logview.md) | `clsAppErrorCollection.RetrieveSQL` — retrieve up to 300 filtered error rows | Inline | `App_Error` | `clsAppErrorCollection` |
| [SQL-006](SQL-006-saif-application-logview.md) | `clsAppErrorCollection.RetrieveSQLCount` — count filtered error rows | Inline | `App_Error` | `clsAppErrorCollection` |
| [SQL-007](SQL-007-saif-application-logview.md) | `clsAppInfoCollection.RetrieveSQL` — retrieve up to 300 filtered info rows | Inline | `App_Info` | `clsAppInfoCollection` |
| [SQL-008](SQL-008-saif-application-logview.md) | `clsAppInfoCollection.RetrieveSQLCount` — count filtered info rows | Inline | `App_Info` | `clsAppInfoCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-009](SQL-009-saif-application-logview.md) | `clsAppError.UpdateSQL` — update `Deleted_Flag` by sequence number | Inline | `App_Error` | `clsAppError` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-application-logview.md) | `Select @@IDENTITY` after `App_Error` insert | Current session identity value | `App_Error` insert context | `clsAppError` |
| [SQL-002](SQL-002-saif-application-logview.md) | `Select @@IDENTITY` after `App_Info` insert | Current session identity value | `App_Info` insert context | `clsAppInfo` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- `Application\SAIF.Application.LogView\clsAppError.vb`
- `Application\SAIF.Application.LogView\clsAppErrorCollection.vb`
- `Application\SAIF.Application.LogView\clsAppInfo.vb`
- `Application\SAIF.Application.LogView\clsAppInfoCollection.vb`