mrc Press Releases

UDFs bring the power of the database to m-Power

November 19, 2008, Lombard, IL - Today, software developer mrc announces new User Defined Function (UDF) capabilities for m-Power, a software development platform designed for use by developers and non-developers alike. m-Power modernizes legacy applications and rapidly creates web applications such as report-writing, business intelligence, executive dashboards, e-commerce, customer portals, and wireless applications to name a few.

With this new feature, m-Power users can take advantage of UDFs when building applications. A UDF is a programmed routine which when passed 1 or more parameters returns 1 resulting parameter. These functions are reusable objects assigned to perform specific tasks. The languages you would use to write a UDF vary depending on the database over which you are running.

Once a UDF is created, it can be reused in any m-Power application because it is defined at the database level. Since m-Power treats a UDF as a database field, a user can select, order, group, or sub-set information by the result of a UDF. m-Power is the first application development platform of its kind to employ UDFs in this way.

"This is a very exciting and powerful enhancement," says Brian Crowley, mrc's Director of Development. "Basically, this enhancement puts the power of the database into the hands of the m-Power user. Anything you can do with a database language, you can now do with a UDF in m-Power."

Here are some examples of how you might use UDFs:

• On Hand Quantity: Calculate a product's current on-hand quantity by combining several fields in the database, and returning the value as a selectable field in the application.
• Dates are often formatted in one way in the database, and a different way in an application. A UDF will reformat the date in the database, and display the reformatted date in the application.
• Order Totals: Give an order number to a UDF and use it to calculate the total value of the order from multiple database tables. m-Power will display the result as a selectable field in the application. In other words, the application will treat the UDF as a selectable field, with the ability to sort or group by the result, even though that field does not even exist in the database.

"m-Power is already a powerful tool in and of itself", says Crowley, "but with this additional UDF ability, the possibilities for m-Power users are truly endless."

Additional information can be found at http://mrc-productivity.com. Or, contact mrc via phone at 630.916.0662; via fax at 630.916.0663; via e-mail at mrc@mrc-productivity.com

About mrc

mrc's development platform, m-Power, is used to create business applications and can run on any platform that supports Java (e.g. OS/400, Linux, Unix, and Windows). Applications access DB2/400, Oracle, MySQL and MSSQL, or any combination thereof. Using the m-Power development platform, users create an endless variety of Java-based business applications from simple queries to reports, to complex custom enterprise systems and dashboards.

mrc was a recipient of the 2004 Apex Award for application development, is a long-time IBM Business Partner, and has been producing award-winning development software since 1981.

2013 Press Releases

mrc celebrates 30 years of software development

mrc releases 4 new m-Power utilities that improve web app development

New white paper explains why native mobile apps are wrong for business

2012 Press Releases

Trinium Technologies and mrc team up to create next generation mobile app

m-Power delivers unmatched results at mobile app competition

Upgraded templates create faster, more flexible web applications

mrc launches cloud partnership program for ISVs

Tomcat 7 support improves m-Power application security and stability

Overhaul of m-Painter makes development simpler, more intuitive

New Timeline Template Provides a Unique Way to Visualize Events

New templates bring cross-tab reporting, spreadsheet uploading to m-Power

Multiple language support is now built into m-Power

m-Power's new application preview window simplifies development

2011 Press Releases

mrc releases video white paper: Why web translation is no longer optional

m-Power delivers unmatched results at modernization competition

Saved searches saves time for end users and developers alike

m-Power Translate tears down the language barrier

m-Power now connects with even more databases

mrc fixes the mobile business application problem

mrc just solved the data conversion problem

mrc improves m-Power's graphing interface

2010 Press Releases

mrc simplifies development and improves application speed

mrc offers new and improved executive dashboards

New whitepapers aim to minimize the risk of application modernization

'What-if analysis' lets you assess changes before they happen

The Project Exchange gives new capabilities to m-Power

mrc brings advanced interactivity to browser-based applications

mrc brings the pivot table to the web

mrc improves m-Power's record filtering

mrc adds SmartLink ability to reporting applications

mrc improves m-Painter functionality with helpers

m-Power's new class of interactive reports encourages informed decision-making

2009 Press Releases

mrc adds flexibility and functionality to m-Painter

New m-Power Interface Simplifies Application Development

mrc launches newly redesigned website

A perfect match: m-Power web applications + Google maps

Business Intelligence Reporting Just Got Better, Faster

m-Power Enhanced to Increase Productivity

Outsource to America

m-Power Enhanced with New Features

Bring Your Ideas to Life

2008 Press Releases

mrc throws down the gauntlet with the m-Power 24-Hour Challenge

UDFs bring the power of the database to m-Power

Say goodbye to email attachments. mrc announces the upload feature!

m-Power launches new demonstration site for Web 2.0

m-Power expands Partnership Programs with new initiatives and incentives.