Function NewDataset only load 100 records

I have a function with the following structure.

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

Hi,

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.

Hi,

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 …

I tried to use ADO but my problem isn’t fixed
Can you help me with other solution for my problem?

Hi,

can you create a simple testcase for me that reproduces this issue, pls?
it should contain also DDL script for creating DB and script for filling that table with some data.
you can drop email with it to support@ for keeping privacy.