Data Not Showing [message #599816] |
Tue, 29 October 2013 04:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/234f90475252485f91c65eeba160c5c7?s=64&d=mm&r=g) |
oradev10
Messages: 7 Registered: October 2013
|
Junior Member |
|
|
I am navigating to a 2nd block and the data appears fine. When I add a default_where clause suddenly the data won't display. I checked in sql plus and I should retrieve 6 rows. I also set up an on-count trigger and saw that the query is retrieving the 6 rows however the block/canvas shows nothing. When I remove the default_where I do get the data showing. Any ideas as to why the default_where is not displaying even though it is querying properly? Thanks in advance.
|
|
|
|
|
Re: Data Not Showing [message #599828 is a reply to message #599826] |
Tue, 29 October 2013 05:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Although you said that query "works", could you double check it? When setting up the DEFAULT_WHERE, compose its value into a variable and display it on the screen (put it into an item or use MESSAGE built-in); then copy/paste it into SQL*Plus and run it. If it is correctly created, it should return these 6 rows. If not, well, you'll probably see the reason.
Also, you could post trigger code you used to do what you are doing.
Just to verify: you did execute query at the end, didn't you?
P.S. Oh, yes - forgot to say: try to recompile the form (All: Ctrl + Shift + K) and see what happens.
[Updated on: Tue, 29 October 2013 05:08] Report message to a moderator
|
|
|
Re: Data Not Showing [message #599829 is a reply to message #599828] |
Tue, 29 October 2013 05:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
use get_block_query(<block name>, last_query) to get the exact select statement submitted to the DB.
Also does the block have any list items, check boxes or radio groups. If so check those items support the values in the corresponding columns for the records that don't display.
|
|
|
|
|
|
Re: Data Not Showing [message #599834 is a reply to message #599832] |
Tue, 29 October 2013 05:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It's simple.
Say you have a list item with two values - Y and N
And you have a row in the table with a value for that column of S.
The list item can't handle that value so the whole record is silently rejected.
If you set the mapping of other values property that will allow the list item to display the record, but really should make sure the data always matches up.
And the exact same logic applies to check boxes and radio groups.
|
|
|
|
Re: Data Not Showing [message #599843 is a reply to message #599835] |
Tue, 29 October 2013 06:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Unsurprisingly I learnt that one the hard way years ago and if memory serves it took a couple of days to work out what the problem was. It still amazes me forms doesn't pop up an error when it can't display a record, I'd call that a forms bug personally.
This issue is the main reason why I always tell people not to try and dynamically populate list items. If the list has different data in different circumstances then sooner or later you will end up with records that can't be displayed.
|
|
|
|
|