[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:	FOCUS, from INFORMATION BUILDERS

Moderator:	ZAYIUS::BROUILLETTE

Created:	Thu Feb 19 1987
Last Modified:	Mon May 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	615
Total number of notes:	1779

238.0. "Sorting with Missing values" by COGVAX::CLIFFORD () Sat Jul 15 1989 18:11

    Does someone have a workaround for sorting on a field that may
    have missing values so the the missing values are the last item
    in the sort?
    
    I put in SET NODATA = 'ZZZ'. Now when it sorts it still 
    comes up first with the ZZZ.  It looks like FOCUS sorts, 
    puts missing values first in the sort order, and uses the 
    NODATA indicator as a label instead of using it in the sort
    routine.                                    
    
    Anyone have a way around this?
    
    Thanks.
    Gary

T.R Title User Personal
Name Date Lines

238.1 DEFINE A TEMP SORT FIELD SCRUZ::PARKER_TY Tyrone Parker WR03-2/M13 Thu Jul 20 1989 13:56 23

T.R	Title	User	Personal Name	Date	Lines
238.1	DEFINE A TEMP SORT FIELD	SCRUZ::PARKER_TY	Tyrone Parker WR03-2/M13	`Thu Jul 20 1989 13:56`	23
	Try a DEFINE statement to define a new field for SORT purposes that you won't print. example; DEFINE ABC/A10 = IF FIELD_NAME IS MISSING THEN 'ZZZ SORT LAST' ELSE 'AAA SORT FIRST'; In Your TABLE request you could use this statement in ADDITION to your other sorts... BY ABC NOPRINT.... Hope it helps... Ty.

	Try a DEFINE statement to define a new field for SORT
	purposes that you won't print.



	example;

	DEFINE ABC/A10 = IF FIELD_NAME IS MISSING THEN 'ZZZ SORT LAST'
                         ELSE 'AAA SORT FIRST';

	In Your TABLE request you could use this statement in ADDITION 
	to your other sorts...


	BY ABC NOPRINT....

	Hope it helps...

	Ty.