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