Home » Developer & Programmer » Forms » Oracle Forms 6i Button Trigger
Oracle Forms 6i Button Trigger [message #78441] Mon, 25 February 2002 01:28 Go to next message
Greg Horton
Messages: 37
Registered: February 2002
Member
Sorry, was that reply meant for me?

varray with form5.0?

DECLARE
CURSOR c1_l1 IS
SELECT distinct honours_points
from students
group by honours_points
having count(*) > 1;
/*CURSOR c2_l1 IS
SELECT count(*) honours_points INTO variable
FROM students
where distinct honours_points > 1;
*/
--
BEGIN
go_block('students');
FOR L1_rec IN c_L1
LOOP
create_record;
:students.honours_points:=L1_rec.honours_points;
/*:students.count_star:=L1_rec.count_star;*/
END LOOP;
END;

Im trying to figure out how to manipulate the count(*) values with no success as yet.. any ideas?

Cheers,

Greg
Re: Oracle Forms 6i Button Trigger [message #78492 is a reply to message #78441] Tue, 26 February 2002 05:51 Go to previous message
Tamim
Messages: 23
Registered: October 2001
Junior Member
Hi,

What are you actually trying to find here? The students who have more than 1 honours_point? If that is what you need to do, then you will have to write your select as such -
SELECT student_no,sum(honours_points)
FROM students
GROUP BY student_no
HAVING sum(honours_points) > 1;

This select will return those student nos and honours points for those students whose honours points total is more than one. If this is not what you needed please mail me and I will get back to you.

Regards
Tamim
Previous Topic: Subclassed objects not subclassing
Next Topic: Problem in run_product
Goto Forum:
  


Current Time: Tue May 26 23:00:33 CDT 2020