Attempt to set a parameter name that does not occur in the SQL : Bind variable

Hi All

Some times we will get an error

Attempt to set a parameter name that does not occur in the SQL : BindvariableName

This error comes when we have a bind variable that is not using in SQL query but using in View Criteria with required as true.

So it's a thumb rule we need to remember is that

If we are using the bind variable in SQL Query of View Object then only we need to check the required check box.

If we are not using in SQL Query but using in View Criteria it should unchecked.

So to get rid of this error uncheck required check box

Thanks
Krishna