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