Retrieve columns not working

Stimulsoft Reports.NET discussion
Post Reply
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Retrieve columns not working

Post by Jennypi »

Hi,

Another issue after I upgrated to prerelease build 22/01:
When I create a new datasource inside a connection, I use to click on Retrieve columns in the SQL editor, in order to get all the fields.
Now when I click this button, nothing happens.
I've just realized that I actually need to create the parameter (used in the query) BEFORE clicking this button. Once the parameter is created, retriveving columns does work.
Maybe an error message should be displayed to tell the user that parameters should be created first?

And what is the purpose of the buttons Retrieve Buttons and Parameters?

Thank you.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Retrieve columns not working

Post by Alex K. »

Hello,

In old version, if in the query or stored procedure using temporary tables was need set the additional option:
StiOptions.Engine.WizardStoredProcRetriveMode
then manually add parameters and retrieve columns.
In last version we moved this option in the Datasource edit window - "Allow Run StoredProc", also has been added new RetrieveParameters option.

Thank you.
Post Reply