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

Use this board to ask questions or have discussions with other Rich Displays users.
robhathome2
Profound User
Posts: 42
Joined: Mon Jun 27, 2011 9:11 am
First Name: Rob
Last Name: Horton
Company Name: Design Group Plc
Contact:

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

Post by robhathome2 »

Hi

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

Thanks

Rob.
User avatar
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

Post 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.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 0 guests