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	clsAppError.InsertSQL — insert an application error log row	Inline	App_Error	clsAppError
SQL-004	clsAppInfo.InsertSQL — insert an application info/audit log row	Inline	App_Info	clsAppInfo

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-005	clsAppErrorCollection.RetrieveSQL — retrieve up to 300 filtered error rows	Inline	App_Error	clsAppErrorCollection
SQL-006	clsAppErrorCollection.RetrieveSQLCount — count filtered error rows	Inline	App_Error	clsAppErrorCollection
SQL-007	clsAppInfoCollection.RetrieveSQL — retrieve up to 300 filtered info rows	Inline	App_Info	clsAppInfoCollection
SQL-008	clsAppInfoCollection.RetrieveSQLCount — count filtered info rows	Inline	App_Info	clsAppInfoCollection

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-009	clsAppError.UpdateSQL — update Deleted_Flag by sequence number	Inline	App_Error	clsAppError

Sequence operations

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Select @@IDENTITY after App_Error insert	Current session identity value	App_Error insert context	clsAppError
SQL-002	Select @@IDENTITY after App_Info insert	Current session identity value	App_Info insert context	clsAppInfo

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference

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