Hi
Did this validation get removed as I still have problems getting a CTE to work?
Thanks
Rob.
Can't get grid with custom sql to display any data
-
- Profound User
- Posts: 42
- Joined: Mon Jun 27, 2011 9:11 am
- First Name: Rob
- Last Name: Horton
- Company Name: Design Group Plc
- Contact:
- David
- Profound Logic Staff Member
- Posts: 690
- Joined: Fri Jan 04, 2008 12:11 pm
- First Name: David
- Last Name: Russo
- Company Name: Profound Logic Software
- Contact:
Re: Can't get grid with custom sql to display any data
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.
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.
Who is online
Users browsing this forum: Bing [Bot] and 0 guests