Re: Filtering Records in SQL Forms 3.0
Date: 1995/08/17
Message-ID: <40vp9j$cgq_at_ns5.nba.TRW.COM>#1/1
pmccarth_at_rpc.unb.ca (Patrick McCarthy) wrote:
>
>
>I have created forms in SQL Forms 3.0 to list values from tables I have
>created on Oracle 7. What I need to filter out records when the form comes
>up. For example, I would like to list, in the form, only employees from a
>certain department.
>
>What is the command for doing this within the Form.inp file and where do I put
>it ?????
>
>
>Thanks in advance
>Patrick McCarthy
>email -> pmccarth_at_rpc.unb.ca
I don't recommend editing the .inp file since items in there are in a very specific order. Better to use your SQL*Forms Designer and fill in the Default Where/Order By block characteristic with your WHERE clause:
WHERE department = 'some_dept'
This will permit only those rows that meet the criteria to be returned.
Hope that helps. Received on Thu Aug 17 1995 - 00:00:00 CEST