mrc logo mrc logo
  • m-Power m-Power
    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
  • Solutions Solutions
    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 and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Build Process
  • Sequencing
Back to Manual

Sequencing

Sequencing is the last required step in the build process. This is a screenshot of the Sequence Field Selection screen:

sequencing

All of the fields that you selected through the Table/Field Selection specification will appear in this drop-down list..  Sequencing will allow you to order your application by any field(s) in either ascending or descending order. To create a sequence key, select the field from the drop-down, then select ascending or descending, and then click "Save".  You can choose as many sequence keys as you like.  The application will be sequenced in the order that you selected the sequence keys.

Once you have selected all sequence fields. You are ready to Build your application! To do so, return to the application menu, and click build.

Sequencing Differences By Application Type

Depending on whether your application is a retrieval, report, summary, or maintainer, the Sequencing specification will look and act differently.

Retrieval: Sequencing in a retrieval is the most straightforward, and will behave as above.

Report: If your application is a report, you will see a Subtotal field in the Sequencing specification. If you want to allow a field to be subtotaled, select yes before adding the key. Now, when the application is run, the end-user can select subtotaling as desired.

Summary: The Sequencing specification in summaries is similar to the Sequencing specification in Reports. However, as summaries write to the database, subtotaling a summary will write subtotal levels to the database.

Maintainer: Unlike other application types, the Sequencing option in maintainers defines the key value.  By rule, the database will not allow you to modify the key value in update mode.  Further, by default, the database will not allow duplicate values as determined by the Key field(s).

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

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

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


© 2024 mrc. All rights reserved.