KB-27338: Filtering alarms starting with a given text.
Question: In a Query, how can I filter alarms with areas starting with a given text? Solution: In order to filter alarms with areas starting with a given text (for…
Category: Elipse E3
KB-27686: Recording TimeStamp in a PLC that is read by multiple tags.
Question: How can I record the TimeStamp in a PLC that is read by six different tags (day, month, year, hour, minute, and second) in the Historic‘s E3TimeStamp field? Solution: …
KB-29787: Recording in a Historic when the minute is a multiple of 15.
Question: How can I record in a Historic when the minute is a multiple of 15? Solution: To do so, you must use the Minute function and a Demo tag…
KB-29915: Vertical movement in chart’s pens.
Question: How can I configure a chart so that pens perform a bottom-up vertical movement? Solution: To do so, configure the numeric scale in the horizontal axis and the time…
KB-29843: Displaying variables with different scales on the same chart.
Question: How can I display variables with different scales in the same E3Chart? Solution: In E3Studio, create an axis for each scale and select the respective axis in each pen’s…
Connecting a VBA application to an E3 Server using the E3DataAccess library.
GENERAL NOTES This article applies to Elipse E3, versions 4.0 or lower. There is a bug when using E3DataAccess library in typeless languages, such as VBScript and JavaScript. This feature…
Settings for enabling network access to SQL Server.
This article illustrates the necessary settings to enable remote access to SQL Server Express 2005. 1. Go to Start–All Programs–Microsoft SQL Server 2005–SQL Management Studio Express and follow the instructions…
KB-28443: Firing an alarm according to the values of multiple tags.
Question: How can I fire an alarm when the values of a Digital Tag and an Analog Tag are, respectively, one (01) and fifteen (15)? Solution: To do so,…
KB-30058: Setting up an E3Chart’s Y axis to display time and X axis to display values.
Question: How can I set up an E3Chart‘s vertical axis (Y) to display time and its horizontal axis (X) to display values? Solution: To do so, follow these procedures: Acess…
KB-32513: Select() and Update() in the same SQL clause.
Question: Can I set a Select() and an Update() in the same SQL clause, similarly to the example below? Update EQUIPMENT Set EQUIPMENT.EQUIPMENT=’‘, EQUIPMENT.DISABLED=, EQUIPMENT.CLASS_EQUIP=CLAS_EQUIP.INDEX, EQUIPMENT.SECTOR=SECTORS.INDEXWhere EQUIPMENT.INDEX= and CLAS_EQUIP.CLASS_EQUIP=’‘ and…