Retrieve Columns with Parameterized Query

johnham · Post by **johnham** » Thu Sep 03, 2009 6:11 pm

Just a small annoyance really but I noticed that I have NEVER been able to retrieve columns in the Dataset Editor if my query contains parameters. Is there a way to have it prompt for some dummy parameters and then retrieve the columns.

Right now if I change the field list on a query I have to temporarily remove any parameters before pressing "retrieve columns".

Any help here would be great.

Post by **Jan** » Tue Sep 08, 2009 5:37 am

Hello John,

Do you mean standard sql parameters or expression in sql query? You have troubles with query to stored proc or to table.

Thank you.

johnham · Post by **johnham** » Tue Sep 08, 2009 10:39 am

If we are using a Query Like:

Code: Select all

Select * From Table Where ID=@ID

If we press "Retrieve Columns", we get an exception. I realize that this is due to the parameters having no value. However, if we press the "View Query" button, it prompts us for the values of all parameters in the query. I would expect kind of the same behavior from pressing "Retrieve Columns".

The only way to work around it currently is to remove all parameters from the query like so:

Code: Select all

Select * From Table

Then press "Retrieve Columns".
Then put the parameters back in after the columns have been retrieved.

Post by **Jan** » Wed Sep 09, 2009 12:53 pm

Hello John,

This is strange behavior. We will check this problem. I will inform you about progress.

Thank you.

Post by **Edward** » Thu Sep 17, 2009 10:31 am

Hi John,

The problem is fixed. Patch will be available in the next prerelease build on Monday, 21st September.

Thank you.

johnham · Post by **johnham** » Thu Oct 01, 2009 1:42 pm

Just got to testing this today. Here is a picture of what happened.

Post by **Edward** » Fri Oct 02, 2009 5:12 am

Hi John,

Yes, it is true that 'Version: 2009.3.501 from 14 September 2009' did not work because this prerelease build was issued before the patch was ready.
The prerelease build from 28 of September extracts columns from SQL Server 2008 correctly, so please just download this prerelease

Please let us know if you need any help.

Thank you.

johnham · Post by **johnham** » Fri Oct 02, 2009 11:57 am

Thanks for the clarification. I must have grabbed the wrong release.

so29 · Post by **so29** » Mon Jun 28, 2010 7:24 am

hi

Yes, it is true that 'Version: 2009.3.501 from 14 September 2009' did not work because this prerelease build was issued before the patch was ready.
The prerelease build from 28 of September

Where do I download this file؟؟

I do not find it here
http://stimulsoft.com/ReportsNetDownloads.aspx

Please guide me

Thank you

Post by **Andrew** » Tue Jun 29, 2010 6:37 am

Hello,

The patch from September is not available. You may download either official release at http://www.stimulsoft.com/Downloads.aspx or the latest prerelease build at http://www.stimulsoft.com/ReportsNetDownloads.aspx .

Thank you.