Home » Developer & Programmer » Forms » Filling datablock
- Filling datablock [message #116284] Tue, 19 April 2005 03:32 Go to next message
jonmich005
Messages: 53
Registered: April 2005
Member
I have set the data block-property 'Numbers of records displayed' on 20.

But now I want to fill this block with 20 different records.
Is this possible? And How do I have to do it? In a procedure or on the property palette?

Now I have this select-statement:
select tl_grid_activity
into :lds_tl_grid.tl_grid_activity
from lds_tl_grid
where tl_grid_id =0
and tl_grid_veh_id = :global.vehicle;

But the grid_id always changes and if I don't include that it gives ora-01422.

I hope someone can give me some information.
- Re: Filling datablock [message #116414 is a reply to message #116284] Tue, 19 April 2005 19:47 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Guidelines for Building Applications'. Download it and read it!

Base the block on the table in the select statement. Unless you have to populate the entries one by one in which case you need to use the 'Create_Record' facility inside a loop that handles each record one at a time.
Previous Topic: frm-40200 I don't know why!!
Next Topic: duplocate detail
Goto Forum:
  


Current Time: Thu Mar 06 05:42:53 CST 2025