How do You Manually Fill In a Prompt without Respecting the Case Sensitivity Constraint?
| The information in the article applies to |
| Synopsis |
You enter values in the prompt in either lower case, or a mix of upper and lower case, and you receive the message "No Data to Fetch".
Cause: All values in the database are stored in upper case and the Oracle database is case-sensitive.
| Solution |
*****CONFIGURATION******
BusinessObjects version 11
*****RESOLUTION******
Use the function UPPER in the definition of the object.
For example:
Object: Select_a_Country
Select: Customer.country
Where: ucase(Customer.country) =ucase(@Prompt('Which Country?','A','Customer\Country',,))
This ensures that the comparison will only take into account uppercase strings.
The WHERE clause above can be embedded in the WHERE clause of an object or it can be in a predefined condition (Insert > Condition).
Have a question for our trainers?
Click here to send your questions!