OraFAQ Forum: Forms » filling list item in detail block

Home » Developer & Programmer » Forms » filling list item in detail block

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

filling list item in detail block [message #475320]

Tue, 14 September 2010 07:19

Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium

Member

Hi all,

We have a master detail form
block A (master) contains an item, this item is in the record group's where-clause used to fill a list item on block B (detail block) (database item)
we fille the list item in a pre-record trigger on the master block
this works fine but when we navigate through the records in block a we intermittently get the following error :
FRM-41337 : cannot populate the list from record group;

any solutions
how should we filll our list item, in which trigger (when-new-record-instance of master block doesn't work correctly, the list item only gets filled after clicking it twice)

Kr
Martin

Report message to a moderator

Re: filling list item in detail block [message #475323 is a reply to message #475320]

Tue, 14 September 2010 07:31

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then presumably for those records the query is erroring. Try running the query in sqplus with the values from those records.

Report message to a moderator

Re: filling list item in detail block [message #475332 is a reply to message #475323]

Tue, 14 September 2010 08:13

Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium

Member

The query is fine,
you cannot populate or clear a listitem
at the moment when there are records in its block

so when do we fill (which trigger) the listitem

Report message to a moderator

Re: filling list item in detail block [message #475335 is a reply to message #475332]

Tue, 14 September 2010 08:16

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Ah, I overlooked that.
Don't use a list item. use a text item with an LOV. Dynamic list items will cause you nothing but grief.

Report message to a moderator

Re: filling list item in detail block [message #475929 is a reply to message #475335]

Sun, 19 September 2010 12:35

nikhilk411
Messages: 33
Registered: September 2010
Location: Mumbai

Member

What if you make the block B as non-database item? Populating a item based on trigger is always less troublesome if it is a non-dB item.

Report message to a moderator

Re: filling list item in detail block [message #475936 is a reply to message #475929]

Sun, 19 September 2010 13:14

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Not sure what you think will be easier about it.
The problem he is currently hitting will remain and you've got to write extra code to copy the value of the item to seperate DB item. It does need to be saved after all.

Report message to a moderator

Previous Topic:	to open another form with the help of hyperlink
Next Topic:	frm-40737

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 02:31:57 CST 2025