Re: How do I select distinct values when user executes query?

From: hazledid <david.hazledine_at_roche.com>
Date: Thu, 22 Jul 1999 16:34:22 GMT
Message-ID: <iKHl3.3790$J5.40086@c01read02-admin.service.talkway.com>

If the SHIP_NO block is only ever used for queries, create a view which does SELECT DISTINCT SHIP_NO and
use that view in your SHIP_NO block. If you want to enter new shipments as well as query
existing ones then life gets more difficult (you can't insert into a view which uses a DISTINCT function).

Options include:

Have a separate block in your form for data entry, which accesses the table instead of the DISTINCT view
Create triggers to override Oracle Forms' default commit processing and code the INSERT etc. statements yourself
Better still, normalise your data model and move shipment information into a separate table with 1 row per shipment

Hope this helps.

David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674

E-mail: david.hazledine_at_roche.com
Fax: +44 (0)1707 325666
Tel: +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Thu Jul 22 1999 - 11:34:22 CDT