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…
Categoria: En
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…
KB-27556: Changing the objects’ activation order.
Question: Can I change the objects’ activation order in the domain? Solution: Yes. To do so, access the E3Studio, load the domain, and select the option Edit Activation Order, by…
KB-31047: Real-time pens disappear.
Question: Why do some E3Chart’s real-time pens disappear after a certain time? Solution: This happens because BufferSize property sets a certain number of pens points to be saved in the…
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…
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…
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…
