Defines where the Query is generated and handled, from a DBMS (Database Management System) point of view. The available options are the following:
•0 - clServer: Query is generated on the DBMS (server)
•1 - clClient: Query is generated on the Server (client, default)
Please check also the CursorType property.
NOTE |
This property has no effect for Databases with the SourceType property equal to 0 - stAccess, because in this case the Server always generates and handles the Query. However, for SourceType equal to 1 - stOracle or 2 - stSqlServer, it is advisable to use the option 1 - clClient. For more information, please check the documentation of the CursorLocation property and the CursorLocationEnum enumeration of the ADO (ActiveX Data Object) object. |