Function NewDataset only load 100 records

I have a function with the following structure.

My code run in version correctly, the method GetTestData return more 1000 records but in the version only show 100 records.


What driver and subdriver you are using.
What is your DB ?

I’m using Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64), the driver is FireDac and the subdriver is MSSQL.


can you try usual ADO for testing, pls?
if it works ok, then something is wrong with FireDAC options or they have change some default values …