OraFAQ Forum: Forms » Oracle Forms 6i Button Trigger

Home » Developer & Programmer » Forms » Oracle Forms 6i Button Trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Forms 6i Button Trigger [message #78441]

Mon, 25 February 2002 01:28

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

Report message to a moderator

Re: Oracle Forms 6i Button Trigger [message #78492 is a reply to message #78441]

Tue, 26 February 2002 05:51

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

Report message to a moderator

Previous Topic:	Subclassed objects not subclassing
Next Topic:	Problem in run_product

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 04:43:42 CDT 2025