Page 2 of 2

Re: Can't get grid with custom sql to display any data

Posted: Fri Jun 14, 2013 10:41 am
by robhathome2
Hi

Did this validation get removed as I still have problems getting a CTE to work?

Thanks

Rob.

Re: Can't get grid with custom sql to display any data

Posted: Fri Jun 14, 2013 11:59 am
by David
We did correct the validation issue, and it is capable of running a CTE now, but we ran into another issue.

The Grid requires that the result set of the query be counted. Our current method of counting dynamic SQL statements does not work with a CTE, so it's failing on the counting step.

We were investigating solutions, but haven't come up with anything yet, sorry.