How to determine maximum records queried by select from client in DA4

Data Abstract
1

What is the advised way to add TOP xxx to the SELECT statement defined in a DA4 schema.

Currently I define a function OffGetData with a parameter MaxRecords:integer
Then in that call I set aTableRequestInfoArray[x].MaxRecords before the call to GetData
I seem to get a dataset of size 1 but in the SQL profiler I see a full select.

Should this work?
What is the advised way to add TOP xxxx to the select based on a client side parameter

2

Hi,

What platform you are using (Delphi or .NET)?
What the DataAbstract version you are using? DA4 ?