Re: [SQL*Forms 3.0] select DISTINCT possible?

You could create a view based on the "select distinct" and then base your block on that view.

Wes.

Frampton Steve R wrote:
>
> Hello:
>
> I'm developing a three-block forms application for tracking
> employee absence information. I'm having difficulty with one
> of the blocks, which is being used to provide summary information
> on absences taken during the year.
>
> For this block, I want to query only the *distinct* absence
> codes taken by the employee, along with the number taken
> during the year.
>
> From SQL*Plus, I can accomplish this with:
>
> select distinct(absn_reason_code),
> sum(total_override_crdt_loss)
> from ec_employee_absn_summary
> group by absn_reason_code
> order by absn_reason_code;
>
> I thought I could just throw this into a PRE-QUERY (I've also
> tried it in a KEY-EXEQRY) trigger, but when I attempt to query
> the records, I get:
>
> "PRE-QUERY trigger raised unhandled exception TOO_MANY_ROWS"
>
> I assume such a thing *is* possible? Any advice would be
> greatly appreciated.
>
> Thanks in advance.
Received on Fri Nov 08 1996 - 00:00:00 CET