Defines where the Query is generated and handled, from a DBMS (Database Management System) point of view. Possible values for this property are 0 - clServer: Query is generated on the DBMS (server) or 1 - clClient: Query is generated on the Server (client, default). For more information, please also check 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. |