001    /***************************************************************************************************
002     *               MODULE DESCRIPTION
003     ****************************************************************************************************
004     *
005     *               NAME:           UpperTextOrderScheme.java
006     *               LANGUAGE:       Java2
007     *               DATE:           27.3.2003
008     *               AUTHOR:         Miika Nurminen, University of Jyväskylä
009     *
010     ****************************************************************************************************
011     *               COPYRIGHT (C) KIURU -PROJECT GROUP
012     *               Limited rights granted. Please refer to license
013     ****************************************************************************************************
014     *  
015     ****************************************************************************************************
016     *               UPDATES
017     ****************************************************************************************************
018     *
019     *   27.3.2003: Initial release / mn
020     *
021     ****************************************************************************************************/
022    package kiurubeans;
023    
024    /**
025     * Default order scheme for textfields.
026     * <br />
027     * Note! Textfield must be applied to actual field names. Aliases cannot be used because of 
028     * upper()-function
029     * @see Field
030     */
031    public class UpperTextOrderScheme extends DefaultOrderScheme {
032      
033      // Operations
034    
035      /** Returns sql clause suitable in <code>order by</code>-clause
036       * @return String that suits in <code>order by</code>-clause
037       */  
038      public String getOrder() {
039        return " UPPER("+getFieldName()+") ";
040      }
041    }
042    /***************************************************************************************************
043     *               COPYRIGHT (C) KIURU -PROJECT GROUP
044     *               Limited rights granted. Please refer to license.
045     **************************************************************************************************/