m-Power Manual

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 Read the rest of this document »

Redirecting a Maintainer Application to Another Page   There will be numerous times you wish to redirect to another page after a user has performed an action on a file (Update, Delete, or Add). One of the most common uses of the redirect is after you have a user fill out a form. Once this Read the rest of this document »

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

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 Read the rest of this document »

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 Read the rest of this document »

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 Read the rest of this document »

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 Read the rest of this document »

Validate User Input   When working within an mrc application that allows end-users to input data, it is often necessary to be able to validate the user’s input. In most cases, validation is usually necessary within a Maintenance application or the prompt page of a Report. mrc offers the following built in validation types for Read the rest of this document »

Validating via a Java External Object   This document will explain how to call an external object Java program for validity checking. For basic information regarding validity checking please see this document. The source code for the Java used in this example can be found here. The purpose of this object is to check to Read the rest of this document »

Validating via an SQL Procedure Source Code   create procedure mrcworklib.validdates (inout i_error char(99),  inout i_strdate decimal(8,0),  inout i_enddate decimal(8,0)) LANGUAGE SQL CASE when i_strdate = 0 and i_enddate = 0 then    set i_error = ‘You have not entered any dates.’; when i_strdate = 0 then    set i_error = ‘You must enter a starting date.’; Read the rest of this document »