Stu412

SQL Fetch command

Discussion created by Stu412 on Oct 27, 2016
Latest reply on Nov 1, 2016 by Stu412

Hi there

 

I'm investigating the use of the ExecuteSQL Fetch command and as far as I can tell it will only return whole rows of data, not specific fields.

 

What I need is the top 25% of results from the overall table for a given criteria.  The reason I'm using ExecuteSQL is because at the stage I need to bring this particular calculation to my report, I have the need to be working in a certain found set.  AFAIK native FM commands won't access records outside of the found set.

 

Thanks in advance

Outcomes