Sample Banners

 

The content of the two banners at the top of the screen as shown above is fully configurable. The content for each is determined by a stored procedure named as follows:

sp_TouchScreenBanner1 for the top banner and

sp_TouchScreenBanner2 for the lower banner.

 

The top banner allows both the banner text and the colour to be determined by the stored procedure where 0 = grey, 1 = green and 2 = red.

 

Each stored procedure is passed a single parameter - the name of the scanner calling the stored procedure. This allows the stored procedures on different scanners to show different messages.

 

The stored procedure is simply required to return 2 lines as shown in the example below:

CREATE PROCEDURE [dbo].[sp_TouchScreenBanner1]

@ScannerName varchar(100)

AS

SELECT 'JOB STARTED Qty 43/45'

SELECT 2

The first select statement contains the text contained in the banner and the second specifies the colour.

The stored procedure is executed automatically on a timer basis so if anything changes, the banner will be updated within a configurable period. In the example above the banner contents are fixed but of course in a live application, the contents will depend on the status of other variables in the database.

 

The second banner works in the same way as the first but has only one select statement required which specifies the banner content. The colour of the second banner can't be changed.

 

The refresh rate of these banners is defined in the Touch Screen Settings tab on the TransLution Settings form on the client which is covered in the EazyTouch Configuration section of the On Line help.