please let me know immdeiately

I am working on forms 6i Oracle 8i,
under WIN-NT 4.0 Workstation.

Please let me know immediately.

My propblem is:

I am not displaying more than one record
in multirecord block from a database table.by writing a select statement in form.

Example:,,

In form, I have a multirecord block
(block name is DEPT and also basetable
name is DEPT). I want to fetch the records
from DEPTNEW table into that multirecord block.

If only one record in DEPTNEW table, then it is worked properly.
But the problem is, if in DEPTNEW table has more than one record
then the records are not displayed in that DEPT block on forms.

(NOTE: DEPT and DEPTNEW both tables have same structure)

Please give me the solution as soon as possible,

thanks a lot for ur cooperation.

my email id is sri_garige@hotmail.com

thank u.

Hi,

I unable to get your proble

Are your fetching the data from DEPTNEW through
procedure, and then save it to DEPT table through
DEPT block.
Pl give some more detail


Thanks
P. Soni

hi,
what i feel from your question is that you want to display records in dept table from deptnew table.If thats true then you have to write a cursor which selects the data from the dept table. Assign the cursor columns to the dept table columns.You will be able to view the records in the dept block.