KB-31594: Processing data from a Query.

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 machine running the Viewer or in the machine running the Data Server?

Solution:

This will depend on the Query’s CursorLocation property. This property establishes where the Query will be generated and manipulated, according to the DBMS (Data Base Management System). The available options are:

• 0 – clServer: the Query will be generated in the DBMS (server).
• 1 – clClient: the Query will be generated in E3 Server (client).

Another property to be observed is Database’s EnableLocalCreation. This property establishes whether the Viewer will create the DB’s connection locally or not. The local connection is only used to create Queries. If this property is enabled (True), the Viewer will try to create the connection locally; if this is not possible, it will retrieve the Query asked in the server.

NOTE: From version 4.6 on, the EnableLocalCreation property has been removed from the DBServer object. Since then, the Viewers have no longer been able to access the database directly, and all access now take place via server.