From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: Perform Data Ordering.
Date: 28 Sep 92 19:08:06 GMT
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
X-Informix-List-ID: <list.1488>


 
     TO: Mark Trotter
 
 
 
     Query by Last Name, First Name, and Date.
 
     The answer to your question is, YES.
 
     This requires three "Query Statements" in the Query Command of
     the Perform Function, and modification of two fields in your table.
 
     First the table modification.
 
          1.   Open the TABLE and check for INDEXED fieldnames, the
               fieldnames for last_name and first_name must be indexed.
          
          2.   If they are not indexed then modify them to be indexed.
               You can use either DUPS or UNIQUE index, UNIQUE will 
               permit only one like name to be added into the database.
 
 
     Now the query statement in the PERFORM function.
 
          1.   In the lastname field query by ">=A*" 
               (NOTE:  DO NOT USE THE QUOTES IN THE FIELD)
 
          2.   In the firstname field query by ">=A*"
 
          3.   In the date field query by the RANGE statement ":"
 
 
     Exanple:
 
          Last Name                First Name          Date Entered
          [f000              ]     [f001             ] [f002    ]
------------------------------------------------------------------------------
          
          Last Name                First Name          Date Entered
          [>=A*              ]     [>=A*             ] [010192: ]
 
 
          010192:123092 (This is the extension of datefield when the
          query exceeds the length of the field, it appears at the 
          bottom of your terminal.
 
     This query will return all rows of all names between the dates of
     1 Jan 1992 and 30 Dec 1992 sorted in Last Name and First Name order.
 
 
          Jones                    Roberet               02/21/92   
          Jones                    Zack                  01/05/92
          Smith                    Adam                  11/10/92
          Smith                    June                  06/13/92
          Smith                    Kathy                 03/02/92
 
          Etc, etc, etc.
 
     This works on my system fine, exccept I don't have enough people
     with the same common last name to sort on first name also.
 
     Hope this helps solve your problem.
 
 
 



					Michael S. Gordon
					Foreman, Gyroscope Section
					Avionics Division 

 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                                                           *
 *  Michael Gordon                           Sacramento Army Depot           *
 *  Foreman, Gyroscope Section               Directorate For Maintenance     *
 *  E-Mail: maint72@saad-emh1.army.mil       Attn: SDSSA-MAV-320             *
 *  DSN:    839-2367                         Michael S. Gordon               *
 *  Comm.:  (916) 388-2367                   Sacramento, CA 96813-5036       *
 *                                                                           *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *