Skip to Content mrc logo mrc logo
  • What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the Web MS Access to the Web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs & Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Development Services Training Mentoring
  • Overview Partners Press Releases Careers Events Contact Blog
  • Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • m-Painter
  • Case Sensitivity within Applications
Back to Manual

Case Sensitivity within Applications

Occasionally, searching in m-Power may result in returning no matching records, despite matching records existing. For example, the value ‘Chicago’ clearly exists within the CITY field in this retrieval. Now, I’ll search for ‘Chicago’. Despite the value ‘Chicago’ existing, matching records are not found. However, if I search for a numeric value, the search returns as expected.

This is a result of case sensitivity. To fix this, we need to look in the SQL Statement tab in Application Properties. Here you will find the caseSensitive property, which has three options. By default, m-Power will change the search value to uppercase. In my example, the record that I was searching for had lowercase letters—but m-Power assumed that I wanted to search in uppercase. This is why no records were returned.

Therefore, I need to select either of the remaining options. If I were to select ‘No case conversion’, my search value needs to be an exact match, including case, to the record in the database. Selecting the last option will change both my database record and my search value to uppercase, returning any records that are a letter-for-letter match regardless of case.

After changing this property to convert both values to uppercase, my search returns the expected record, no matter the case.

 

Created: December 4, 2012 | Modified: December 3, 2013

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Database Form Validation Performance Reports Tomcat Retrieval Graph Properties App Properties Retrievals Freemarker RPG Compiling Maintainer Dates Application Properties Email Data Dictionary External Objects Parameters Excel Calculations Record Selections Java Graphs SQL Security DB2 Getting Started Advanced Dropdowns Graphing m-Painter Build Process Video Production Bar Graphs Administration Prompt Screens Maintainers Report Admin mrc-Productivity Series Bootstrap Templates Summaries Popular

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© mrc. All rights reserved.