COPYRIGHT NOTICE. Copyright © 2005 Sprezzatura Group, 45 St Mary's Road, Ealing, London, W5 5RG, UK. All Rights Reserved.

Introduction

With the introduction of  OI 7.1.1 it became possible to intercept debugger crashes and substitute the call to the debugger with a call to a developer's own routine. For people deploying commercial applications this a real benefit as users frequently ignore crashes and just continue without providing vital feedback. To capitalise on this capability Sprezzatura are pleased to announce the general availability of S/Log - a routine for updating the Windows Event Log with any information the developer wishes to put there.

Installation

Installation is straightforward. Unzip the downloaded file to a CLEAN subdirectory then log into the application in OpenInsight you wish to use S/Log in. Open the system monitor and type

RUN RDKINSTALL "Location" 

and press return - where location is where you have unzipped the slog.zip file to.

Using S/Log

S/Log installs the following records into your system.

Stored Procedure Debug Tables

Stored Procedure Executables

Stored Procedure Inserts

The routine that you'll actually be using is ZZ_EventLog which takes four parameters as follows

Result = ZZ_EventLog(sourceName, eventType, eventID, eventText )

The system will provide meaningful defaults for all of these parameters other than eventText.

EventText
This is the text to put into the event log.

This results in an event log entry as follows :-

SourceName
This is the source name to put into the event log. The default is "OpenInsight" but you can change this to be your own application.

This results in an event log entry as follows :-

EventType
This is the event type to put into the event log. The default is None (Success)  but you can change this to be any of the values in the insert row EventLog_Equates.

This results in an event log entry as follows :-

EventId
This is the event id  to put into the event log. The default is 1000 but you can use whatever numbering convention you want.

Error Trapping

If S/Log fails it will return a zero. The developer can check for this and use Get_Status for a meaningful description of the error encountered.