Re: Populating rows of records using Forms 5?

Hi,

Want to populate a block? How about EXECUTE_QUERY? What you're trying to do is totally redundant and should be avoided. Why reinvent the wheel?
Define your block using a basetable item, define your items from your base table (select the columns), press GENERATE and VOILA it works! No programming necessary.

• Peter H. Larsen Oracle Consultant

vthean_at_yahoo.com wrote:
>
> Hi, I'm new to Oracle Developer 2000; I need your help
> on how to populate rows of records with multiple
> columns to a data block. I created a data block(Block8)
> with two fields, last_name and first_name. I was able to
> populate only one row of data on the first display item
> but not the rest. I did set the "Number of Records Displayed"
> in RECORD on the property page for Block8 to 3. How do I
> get all the names to populate in block8? Thanks in advance.
>
> Newbie,
>
> --Vandy
>
> Below is my source:
>
> ***************
> declare
> lname varchar2 (20);
> fname varchar2 (20);
>
> cursor emp_tab is
> select last_name, first_name
> from employee_master
> where department = :block3.dept;
>
> employee_info emp_tab%ROWTYPE;
>
> begin
> open emp_tab;
> fetch emp_tab into employee_info;
> while emp_tab%found
> loop
> :block8.last_name := employee_info.last_name;
> :block8.first_name := employee_info.first_name;
> fetch emp_tab into employee_info;
> end loop;
> close emp_tab;
> end;
> *********************************
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

--

Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria
Phone: 703-914-9800 #103
Fax: 703-914-9804
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my employer. Received on Tue Jul 07 1998 - 13:59:10 CDT