Re: query trigger

On Wed, 21 May 2003 19:13:17 GMT, drukqs <invalid.drukqs_at_NOpandoraSPAM.belgie> wrote:

>andrewst wrote in news:2901810.1053445949_at_dbforums.com:
>
>> SELECT pcnr, n
>> INTO :testblock.pc, :testblock.number
>> FROM
>> (
>> SELECT pcnr, sum(number) AS n
>> FROM orders
>> GROUP BY pcnr
>> ORDER BY sum(number) desc
>> )
>> WHERE ROWNUM = 1;
>
>This gives this error when I compile:
>Encountered the symbol "ORDER" when expecting one of the following
>.(),*@ and so on........
>
>What shall I do?

ORDER BY 2 should do OK. I don't see any references to forms and/or server version. The PL/SQL of Forms is usually lagging behind.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 21 2003 - 15:37:57 CDT