OraFAQ Forum: Forms » Filling datablock

Home » Developer & Programmer » Forms » Filling datablock

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Filling datablock [message #116284]

Tue, 19 April 2005 03:32

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.

Report message to a moderator

Re: Filling datablock [message #116414 is a reply to message #116284]

Tue, 19 April 2005 19:47

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.

Report message to a moderator

Previous Topic:	frm-40200 I don't know why!!
Next Topic:	duplocate detail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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