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?
    Solutions by Industry
    Overview Database Front-Ends AI 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
  • Build Process
  • Application Settings
Back to Manual

Application Settings

The Create a New Application screen and the Applications Settings specification are both similar. When first creating your application you will be brought to the Create a New Application Screen. Should you wish to make a change to anything initially specified, you cannot return to that screen. Instead, you can use the Application Settings specification to make any of those changes.

Create a New Application Screen
Application Settings

Create a New Application Screen

After first selecting to create a new application, m-Power will bring you to the following screen:

create_new_app1

The various inputs and selections that need to be made on this page vary depending on template type. There are a few required steps for all types of templates:

The Application Number is automatically generated for you, and auto populates in increments of 10. If desired, you can change this number as long as no two applications of the same type have the same application number.

The Application Description will be seen by both you and your end user. You will see it as your application's title within the m-Power interface, while your end user will see it at runtime as the title to the application.

The Template Selection option controls the look and functionality of your application. Each template has different requirements and offers different features. For more information on selecting a template, click here.

Application Settings

Notice that the Application Settings specification is quite similar to the Create a New Table Screen, but has two additional features:

app_settingsX

Use the Select Only Matching Records feature to choose either a SQL left or inner join, with the default being a left join. The left join will select all records from the primary table and all matching records from secondary tables, whereas the right join will select records from the primary table and secondary tables only where matching records exist.

A left join returns the red (left and center) areas of this Venn Diagram

leftjoin1

A Inner Join returns the purple (center) area of this Venn Diagram

innerjoin1

The Specification Security option determines who can modify the application. If it is set to private, then only you can modify the application. However, any end user will still be able to run the application.

The Compile Options allows you to choose either an Advanced Search Row or an Advanced Search Dialog. The Advanced Search Row appears as search boxes in the table header, whereas the Advanced Search Dialog appears as a button which, when pressed, displays a popup window with search boxes.

Created: July 3, 2013 | 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

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

See all tags »

mrc

Build the custom apps and AI tools your business needs with m-Power, or have our Chicago-based team build them with you. One platform, one team that makes sure you succeed.

Since 1981 · 1,500+ customers · 4.7/5 on G2

m-Power
Overview Demos Build Process Licensing Specs Get a Demo
Solutions
Database Front-Ends Reporting AI Tools Dashboards ERP Enhancements Modernization See all solutions
Company
Case Studies Services About Blog Careers Contact Support

Privacy Policy Cookie Policy Cookie Settings

michaels, ross & cole, ltd. (mrc)
US: 2001 Midwest Road, Suite 310, Oak Brook, IL 60523 · 630-916-0662
UK: Mortlake Business Centre, 20 Mortlake High Street, London, SW14 8JN · +44-20-335-59566
© mrc. All rights reserved.