To be able to use stored procedures which contain cursors, you have to turn off FMTONLY
in a seemingly never executed statement. In this way the data schema can be read by the Data Explorer
as each state of IF-ELSE
statements is evaluated when the SQL query
is run by the SqlDataSource Wizard
. The check will be skipped when the same SQL query is used by calling application at run-time.
You may use the approach from How to configure Stored Procedure with Temporary Tables for use with SqlDataSource componen
t KB article and modify the stored procedure as follows:
. . .
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items