ABDug

Thank you, that worked.

I'm moving a significant amount of code from another set of data access components to FireDAC. In the previous components, FindLast and Last did the same thing. We were in the habit of using the Find__ versions because they return a success/failure flag.

Thanks again, I can work with this.

If I connect a TFDTable to a MariaDB table containing 2000 rows, and immediately call FindLast(), I get back True for success, but it positions on the 100th row of the table, not the 2000th.

FDTable1.Open();
B:=FDTable1.FindLast();
Memo1.Lines.Add(Format('Return=%s A=%d', [NameFromBoolean(B), FDTable1A.AsInteger]));
FDTable1.Close();

I'm running Delphi XE10.2. I've dug through the FireDAC source code and found it is applying LIMIT 100 to the initial select query to populate the TFDTable, but I'm not understanding why the FindLast runs in that initial query result rather than the whole table.

Is there any workaround for this? Thanks.