Question: How can I use a Query’s GetAsyncADORecordSet method? Solution: The GetAsyncADORecordSet method creates a Query that, once finished, generates the Query’s OnAsyncQueryFinish event, passing to this event the generated…
To create a cumulative sum of a table field, you can set up a Query with SQL’s Inner Join command. Example: Date/Hour Field Accumulated 20/02/2014 09:54:05 1 1 20/02/2014…
Question: On a network containing a machine dedicated specifically to the Data Server and others to E3, where is the data from a Query inside the Viewer processed: in the…
Question: How can I execute an Oracle’s StoredProcedure via E3? Solution: In a Query, use the SQL command “call” + StoredProcedure name. For example: – E3 Query: call HourmeterIncrement(‘I724EMD1111’,1) –…
Question: Why is the data format being regarded as month/day instead of day/month in a Query’s filter by date when the day is a number lower than 13? Solution: This…
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 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: How can I filter the first and last records in a query, and then add them and/or subtract one of the other? Solution: Via GetADORecordset method, you can retrieve…
Question: How can I run a Stored Procedure in E3 that passes input data and reads output data? Solution: To do so, follow these procedures: 1. Declare the output variable:…
Question: How can I have a script search for the last value that was recorded on a table? Solution: To do so, you must set up an SQL query that…