Defines the location where a 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 a DBMS (server), 1 - clClient: Query is generated on a Server (client, default), or 2 - clCached: Equivalent to the value 1 - clClient, but the results of this Query are first downloaded to the final client of this Query, such as E3Run or Elipse Water Viewer. For more information, please also check the CursorType property.
NOTE |
The value 0 (zero, clServer) has no effect for Databases in which the SourceType property is equal to 0 (zero, stAccess), because in this case the Server always generates and handles a Query. However, for other values of the SourceType property, it is recommended using the value 1 (one, clClient) or, in case of frequent or fast Queries, it is recommended using the value 2 (two, clCached). For more information, please check the documentation of the CursorLocation property and the CursorLocationEnum enumeration of the ADO (ActiveX Data Object) object on Microsoft Learn. |