KB-27220: Authentication error on MS SQL Server.
Question: Why is thre an authentication error when I try to establish connection with an MS SQL Server database? Solution: To fix this, you must use the MS SQL Server’s…
Category: Elipse E3
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…
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…
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…
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-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…
KB-29734: SQL Query returning a single value.
Question: In an application, an SQL Query returns three values to a certain field. How can I set this Query up to return only one of them? Solution: To do…