Substitute footing print based on subtotal.

[Jesse, Rich]

Hi all,

I'm not sure how to explain what I want, so I'll start with my current QUIZ
code on 8.13D1 -- the memory leak version -- on HP/UX 10.20:

	ACCESS MY_ORACLE_TABLE

	DEFINE	MY_TEST_X NUM = 1 IF MY_COLUMN = "X" ELSE 0
	DEFINE MY_TEST_Y NUM = 1 IF MY_COLUMN = "Y" ELSE 0
	DEFINE MY_TEST_Z NUM = 1 IF MY_COLUMN = "Z" ELSE 0
	DEFINE MY_TEST_OTHER_IDX NUM = INDEX("XYZ",MY_COLUMN)
	DEFINE MY_TEST_OTHER NUM = 1 IF MY_TEST_OTHER_IDX > 0 ELSE 0

	SORT ON MY_INDEX_COLUMN

	FOOTING AT MY_INDEX_COLUMN
		MY_INDEX_COLUMN		&
		MY_TEST_X SUBTOTAL		&
		MY_TEST_Y SUBTOTAL		&
		MY_TEST_X SUBTOTAL		&
		MY_TEST_OTHER SUBTOTAL

What I want is a "yes/no" in place of the SUBTOTALs.  "Yes" if a subtotal >
0, "No" if = 0.

Due to certain other complications which I don't want to get into, this
really needs to be done in one pass.

Can this be done???

Rich Jesse                          System/Database Administrator
Rich.Jesse@qtiworld.com             Quad/Tech International, Sussex, WI USA


-----------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.