It is well known that fields that are formatted as true dates can be easily compared and manipulated. For instance, getting days between two dates is easy with the DAYS() function. Also, it is easy to add or subtract a certain period of time with SQL. More on date functions within SQL can be found… Continue reading »
Joining Tables with Different Justifications
Many people know about *RIGHTJUST being able to allow for filtering and record selections when running apps. However, there is also a way to join two tables together on a field that is justified differently (left-justified in one table and right-justified in the other). To do so, simply build the app as desired, being sure… Continue reading »
Determining "Days From…" in a Report
For years, m-Power users have utilized the Java Date Translator for all of their date needs. However, one big drawback of using the Java Date Translator external object was the fact that you could never use the output field as a record selection or sequence key. To make matters worse, you also couldn’t sort by… Continue reading »
Using functions in your servlets
One of the little known features of m-Power is the ability to call your own functions (or native database functions) through calculated fields. I’m going to show you how to do it with a pretty powerful example that takes about five minutes to build. First, some background Every database has its own rules regarding functions… Continue reading »