Creating reports and dashboards | Stimulsoft community forum

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.

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.