Events Advanced Features window

Event Name Calculation (optional SQL)

Specifies the name of the SQL string used to store the procedure that automatically assigns event codes.

Function Name Calculation (optional SQL)

Specifies the name of the SQL string used to store the procedure that automatically assigns function codes.

To create a stored procedure

1. From the menu bar, select Utilities > SQL Query to open the SQLQuery window.
2. Click New.
3. Enter the SQL command in the SQL Command Text field. For example, the following SQL command will create a stored procedure to generate unique, consistent event codes that include the year and event number count:

CREATE PROCEDURE Meeting_Calc @MeetingCounterName varchar (30) AS  
  
Declare @MeetingCounter int, @Count int  
select @Count=Count(*) from Counter  
where COUNTER_NAME=@MeetingCounterName  
if @Count=0  
begin  
insert into Counter (COUNTER_NAME,LAST_VALUE)  
values (@MeetingCounterName,1)  
select @MeetingCounter=1  
end  
else  
begin  
update Counter set LAST_VALUE=LAST_VALUE+1  
where COUNTER_NAME=@MeetingCounterName  
select @MeetingCounter=LAST_VALUE from Counter  
where COUNTER_NAME=@MeetingCounterName  
end  
select convert(varchar,datepart(yy,getdate()))+convert(varchar,@MeetingCounter)

4. Click Execute.

To set up event and function name calculations

1. From Events, select Set up module.
2. Click Advanced.
3. Click Edit.
4. Enter the SQL string that executes the stored procedure in the Event Name Calculation field or the Function Name Calculation field. For example, enter Meeting_Calc 'MeetingCounterName' in the Event Name Calculation field.
5. Click Save.