Home » Developer & Programmer » Forms » Oracle Forms 6i Button Trigger
Oracle Forms 6i Button Trigger [message #604] Sun, 24 February 2002 23:41 Go to next message
Greg Horton
Messages: 37
Registered: February 2002
Member
Hi guys, ive just joined the forum and havent used one before - so please forgive me if i do anything wrong.

Im currently developing an Oracle form to do some basic datamining and have the following questions:

I have a button on one of my canvas's and when pressed i need it to:
1) Execute a SQL statement (possibly stored in a procedure) to populate a cursor.
2) Populate a designated block with the contents of this newly filled cursor.

Any feedback would be greatly appreciated. I have basic knowledge of forms and a reasonable understanding of oracle and pl/sql, so please be gentle with the level of techiness in your reply!!

Cheers, Greg
Re: Oracle Forms 6i Button Trigger [message #605 is a reply to message #604] Sun, 24 February 2002 23:55 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
here is the code to that...
declare
cursor xyz is
..........
begin
go_block('your block');
for tmp in xyz
loop
create_record;
populate the record...from the cursor....
end loop;
end;

i think i am pretty clear.
Previous Topic: Re: designer 6i repository installation
Next Topic: How do I move alerts please?
Goto Forum:
  


Current Time: Thu Mar 28 14:38:35 CDT 2024