SQLForms30 questions - HELP!

I need some help with SQL*Forms30.

I have an application where I want to generate a form that looks like the following:

where THINGS is a specific column from a table, and COUNT is the number of times that a specific THING appears in the column.

My problems are as follows:

1. How do I get the THINGS column to report only distinct THINGS? I want to do the following in an SQL query:

                SELECT DISTINCT THINGS FROM THING_TABLE; and have the results appear in my THINGS column, but I cannot figure out how to get the DISTINCT clause into the form block's query.

        2. For some reason that I do not understand, when I set up a POST-CHANGE trigger on the THINGS block with text something like:

	SELECT COUNT(THINGS) 
	INTO :form.Count
	FROM THING_TABLE WHERE THINGS = :form.Things;

my COUNT column fills with zeros.

Can anyone out there in net-land help me with these two problems? Received on Thu Mar 31 1994 - 19:28:11 CEST