| Data is not refreshing after execute query in detail block [message #431932] |
Fri, 20 November 2009 02:12  |
isoohail
Messages: 8
Registered: November 2009
Location: Pakistan
|
Junior Member |
|
|
Please Someone help. Whenever i execute query in master block all goes fine. detail block also populated with data but when after executing in master block i need to execute query in detail block on some criteria. query goes fine and required record is selected but now how i refresh this block to show all records. Data is not refreshing after execute query in detail block
Thankx
|
|
|
|
| Re: Data is not refreshing after execute query in detail block [message #431954 is a reply to message #431932] |
Fri, 20 November 2009 03:55  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If it is a master-detail relationship, detail block will display records related to data stored in master block. You can, though, further restrict data retrieved in detail block, but - fetching ALL records (i.e. not related to master) ... I don't know. Is it possible? Why would you want to do that? In that case, you don't need master-detail relationship.
Or, if I misread the question, did you perhaps set DEFAULT_WHERE detail block property which prevents all records (but related to master) to display? If so, remove it! (or use ONETIME_WHERE instead).
|
|
|
|
| Re: Data is not refreshing after execute query in detail block [message #431965 is a reply to message #431954] |
Fri, 20 November 2009 04:27 |
isoohail
Messages: 8
Registered: November 2009
Location: Pakistan
|
Junior Member |
|
|
Dear Littlefoot
Thank you for response
Yes it is right i have used the default_where to query records in both master and details.
in detail block default_where is used in a text box other than the master and detail block. I executed the query to further restric the record say by date in detail block.
I am talking about fetching ALL records related to master record
thank you once again
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
