When running a query with a prompt variable and after typing in a numeric value for the Prompt, receives error:
Error: 'Comparison operator = operands not compatible'
When 'ENTER" is pressed for the Prompt, then the query returns data.
When no value is enter for the prompt variable and presses "Enter", the query interprets this as the query not needing the condition. If there's no value entered, there's nothing to condition. Therefore, Query, in essence, "removes" the condition from the query, and returns all values.
For more information about prompts or variables, refer to ShowCase online help (search words: PROMPT or VARIABLE
Still have questions? We can help. Submit a case to Technical Support.