Skip to Content

How to Convert a Control to All Uppercase

Configuration

  1. Navigate to the panel containing the control you want to modify
  2. Go to Action Drawer > Live Designer
  3. Click the panel's Business Logic gear icon
  4. Click the Columns tab
  5. Locate the Column you wish to modify. For example: CompanyName

  6. In the Column or Expression field, insert UPPER() around the existing Table.Fieldname. For example: 

    UPPER(C.CompanyName)

  7. Enter an Alias for the Column. For example: UpperCompanyName

  8. Click the checkmark icon to Save
  9. Return to the application view and confirm the update

Step-by-Step Guide

  1. Navigate to the Panel containing the Control you want to modify, and go to Design this Page
  2. Select the Panel you are making this change to, and click on the corresponding Business Logic icon
  3. Under the Rules heading, you want to click on the SQL icon for the Data Object containing the field you're modifying
  4. Under the Columns heading, locate the Column you wish to modify and click on the corresponding pencil Edit icon
  5. In the Column or Expression field, insert UPPER() so that it appears around the existing Table.Fieldname. For example: 
UPPER(C.CompanyName)
  1. Click the check icon to Save

2018 04 02 16 18 32 Business Sql Customers Allcaps Vinyl Ide

When you refresh your web browser, you should be able to see the change to the Control on the Panel.