Populating rows of records using Forms 5?

From: <vthean_at_yahoo.com>
Date: Tue, 07 Jul 1998 14:58:10 GMT
Message-ID: <6ntd22$50d$1@nnrp1.dejanews.com>

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 Received on Tue Jul 07 1998 - 09:58:10 CDT