TAstaClientDataSet.GetNextPacketLocate
Applies to
TAstaClientDataSet
Declaration
function GetNextPacketLocate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions):
Integer;
Description
GetNextPacketLocate works like the TDataSet.Locate but it will use the query created from step #1. Depending on your database on the server, this can be a very fast operation. Using a file server database like DBISAM, locates will use indexes if the SQL does not include a join. The GetNextPacketLocate will call a TDataSet.Locate on the server and return RowsToReturn rows, and place the server side cursor on the position where the locate has positioned it. This can result in very fast fetches on large tables. Your mileage will vary depending on how the database component used on the server handles this.
|