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 Data Exploration Reporting Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Database Front-Ends
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Overview Training Project Consulting Staff Consulting 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
  • External Objects

Business Rules Designer

Business Rules Designer   Overview The Business Rules Designer allows developers to create their own custom business processes, directly in m-Power, without any coding. These business rules can be invoked on a per row basis (such as returning a result for every record in a report), per action (such as calling logic when a user […]

Tags: External Objects

Return Data External Object

Return Data External Object   Beginning with the May 2013 update of m-Power, developers will have access to a Return Data Java external object for use within maintenance applications. This object takes in 1 parameter to find a row within a retrieval, and then returns that value(s) to your maintainer. A common example of using […]

Tags: Email, External Objects, Maintainers, Popular

Regular Expression External Object

Regular Expression External Object   Beginning with the May 2013 release of m-Power, developers will be able to use a Regular Expression Java external object for parsing field values. The most common example of when this would be done is with the Email Upload template, in order to grab a piece of data from one […]

Tags: External Objects, Popular

Working with Lengthy Fields

Working with Lengthy Fields   m-Power has always easily handled fields of lengths less than 1000 characters. Beginning with the August 20th, 2012 update, fields of any length can be used within m-Power. When registering tables, simply add them as normal and the proper field lengths will be registered: Calculations also now support large field […]

Tags: Calculations, External Objects

Sample External Object (Java) Source Code

Sample External Object (Java) Source Code   package MRCWORKLIB; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.apache.log4j.Logger; import com.mrc.dbo.MrcConnection; /**  * Delete Order # from MRCWORKLIB.ORDDET  * 2011-09-22  * @author RH  *  * 2. Define external object  *  * Class Name: MRCWORKLIB.DELDETAIL  * Method Name: run  * Then define one object parm to […]

Tags: External Objects, Java

Sample External Object (SQL) Source Code

Sample External Object (SQL) Source Code   CREATE procedure MRCWORKLIB.DELDETAIL(  inout orderno decimal(6,0)) LANGUAGE SQL IS DETERMINISTIC MODIFIES SQL DATA BEGIN DELETE FROM MRCWORKLIB.ORDDET WHERE ORDNUM = orderno; END

Tags: External Objects, SQL

Sample External Object (RPG)

Calling a Sample External Object (RPG)   This document will explain how to create, register, and call a sample External Object written in RPG. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]

Tags: Advanced, External Objects, Maintainers, RPG

Sample External Object (SQL)

Calling a Sample External Object (SQL)   This document will explain how to create, register, and call a sample External Object written in SQL. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]

Tags: Advanced, External Objects, Maintainers, SQL

Sample External Object (Java)

Calling a Sample External Object (Java)   This document will explain how to create, register, and call a sample External Object written in Java. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this […]

Tags: Advanced, External Objects, Java, Maintainers

Validating via Javascript in Reports Source Code

Validating via Javascript in Reports Source Code   <script type="text/javascript"> function validate_form ( ) //Check two dates, DATEORD & DATEEXP in Maintenance application {     valid = true;     if (document.FORM_R00230.R001.value == 0 && document.FORM_R00230.R002.value == 0)     {         alert ( "You have not entered any dates." );         valid = false;     }else if (document.FORM_R00230.R001.value == 0)     {         alert […]

Tags: External Objects, Form Validation, Javascript, Prompt Screens, Reports

More Results »

Search

Browse By Category

Build Process (14)
Starting with m-Power (8)
Retrievals (10)
Reports (14)
Summaries (4)
Maintainers (18)
Graphs (8)
m-Power Data Explorer (4)
General (21)
Calculations (5)
Utilities (8)
m-Power Administration (20)
Security (11)
Freemarker (6)
m-Painter (27)
Form Validation (5)
External Objects & UDFs (11)
Deprecated Documentation (33)
Bootstrap Templates (7)

Popular Tags

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

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2018 mrc. All rights reserved.
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