Re: SQL statement and Oracle Reports

From: <rtproffitt_at_my-deja.com>
Date: Thu, 21 Oct 1999 15:33:21 GMT
Message-ID: <7unbo1$67j$1_at_nnrp1.deja.com>


Adding to what Dan has suggested,

Similarly, your lexical could be

    Select * from table &MyWhereClause;
The user still sets / passes the Event parameter. Then in a parameter form trigger, you validate the :Event and create the proper where clause, like so.

Parameters

  • Event
  • MyWhereClause

Pre/Post parameter trigger:
If :event is null then
:MyWhereClause := NULL;

Else
:MyWhereClause := 'Where eventnumber = '||:Event;
End If

Robert Proffitt

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 17:33:21 CEST

Original text of this message