Forum Discussion
Solved
Improving Workbook Behavior
I notice that some of the workbooks display an error , such as Query could not be parsed at ')'.... click to retry. This occurs when an item has not yet been selected. What is the recommended way to ...
Dean_Gross If you go to the Advanced Settings tab of the step that will provide the parameter, look at the parameters being exported. When setting up a parameter that gets exported, you can setup a default value as well. I would recommend setting that to a value that will cause no rows to be returned in your query but will not return an error.
For text values I typically set this to an empty string and for integers I use zero but it will all depend on the query where it the parameter will be used.
Dean_Gross My bad. You have to click on the parameter, Resource in your image, to see the field to enter a default value. Each parameter can have a different default value.