Overview
m-Power applications can accommodate right justified character fields in SQL. In the past, if you had an 8 length and 12 length character field that we right-justified in the data, you would need to build logical fields over these character fields so that they each were 8 positions to ensure the correct data was being compared.
However, with m-Power applications, you no longer need to create these logical fields to convert your data. Instead, all you will need to do is specify Right Justification on the field in question. To do this, click on the Field Settings option within your application’s Data Model and select the field in question:
Simply add “*RIGHTJUST” to the Field Description, as shown in the above image. Rebuild your application after making this change (no HTML overwrite required).
At runtime, the *RIGHTJUST will not be included within the skeleton of your HTML.
Note that you can also specify Right Justification at the Data Dictionary level for any fields in Admin -> Manage Tables.
*RIGHTJUST is a very useful tool at runtime, however it cannot be used to join tables together (if, for instance, one field in the first table is right justified and the field you wish to join on in the second table is left justified). Instead, please see this post on our Tech Blog for instructions on how to join in such a situation.