SQL-001: clsAppError identity retrieval

This statement runs immediately after clsAppError inserts a new App_Error row. It reads the current SQL Server session identity so the BOF object can store the generated AppErrorSeqNum on the newly saved object.

Classification

Field	Value
SQL ID	SQL-001
Operation type	Sequence
Execution method	Inline SQL
Database	SQL Server
Schema	N/A
Command type	Text
Business object	clsAppError
Criteria property	N/A — DR2.SQLStatement literal
Lifecycle method	BeforeInsert (IdentityRetrieve)

Parameters

Parameter	Direction	Type	Max length	Description
None	N/A	N/A	N/A	No bind variables are present in the SQL text.

Tables

Table	Access	Columns used
None	N/A	No tables are referenced directly; this statement reads the current session identity value after the preceding insert.

Sample SQL

-- Read the current SQL Server identity value for the session
Select @@IDENTITY

Operations and processes

• Create a new application error log entry from struct
• Create a new application error log entry from discrete parameters

Sources

• Application\SAIF.Application.LogView\clsAppError.vb