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>
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