Re: Need SQL*Forms 3 trigger help.

From: Kim Ng <kimmng_at_eskimo.com>
Date: 1995/07/22
Message-ID: <DC3EF7.yA_at_eskimo.com>#1/1


The easiest way is:
(1) get a unique SSN (either from a master table or a view with

    "select unique SSN ....")
(2) get a unique SSN and AWARD from a view "select unique SSN, AWARD ..."
(3) create master detail relationship with (1) as master and (2) as detail.
(4) populate the "Last Date Received" and "Number Received" in "POST-QUERY"

    of the detail ("select max (award_date)...." and select count(*) ...")

Another way is to write cursors and populate the fields --- not recommended, especially if you don't understand what I am talking about in this sentence.

Have fun.



 Mr. Kim Ng (President)
 Paradigm Computer Consulting, Inc.
 20611 E. Bothell Everett Hwy. S.E., Suite 280  Bothell, WA 98012
 e-mail: kimmng_at_eskimo.com Received on Sat Jul 22 1995 - 00:00:00 CEST

Original text of this message