Question: How can I convert a date returned in the Query (E3TimeStamp) into UTC/GMT time zone? Solution: To do so, you can use SQL’s DATEADD function. Example: SELECT DATEADD(minute, ,…
Question: How can I record in the database which user was logged in when the alarm went off? Solution: To do so, one alternative is to use an internal tag…
Question: Is there any property that indicates which alarm is currently selected at E3Alarm? Solution: To do so you can use GetFocusedEvent() event, which has been a feature in E3…
Question: How can I change the text and background colors of the alarms in E3Alarm? Solution: This can be done in E3Alarm‘s properties, on Colors tab. At runtime, whenever a…
Question: How can I change the type of text being displayed in an E3Browser or Report (for example, to have it display True or False instead of 0 or 1)?…
Question: Why is the name of the operator logged into the application not being displayed in E3Alarm‘s Operator field? Solution: This is because E3Alarm‘s Operator field shows the contents from…
Question: How can I implement an alarm filter by type (Alarm or Event) by using a ComboBox? Solution: To do so, you must first insert a ComboBox onto the same…
Question: How can I update or delete a selected record in E3Browser? Solution: To do so, you must first add a script to E3Browser‘s Click or DblClick events using GetColumnValue…
Question: Why does a table generated inside SQL by E3 not allow writing NULL values in their fields, unlike Oracle? Solution: First, you need to understand each database’s behavior when…
Question: In an application storing both the Alarms and Events records in the Alarm Server, how can I set up the E3Browser to display only Alarms? Solution: In the E3Browser…