Home » Developer & Programmer » Forms » Data is not refreshing after execute query in detail block (forms 6)
Data is not refreshing after execute query in detail block [message #431932] Fri, 20 November 2009 02:12 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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 Go to previous messageGo to next message
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
Re: Data is not refreshing after execute query in detail block [message #432073 is a reply to message #431965] Fri, 20 November 2009 22:52 Go to previous message
isoohail
Messages: 8
Registered: November 2009
Location: Pakistan
Junior Member
Dear Littlefoot
Problem is solved.
Thank you
Previous Topic: Navigate to tab item at start
Next Topic: Developer 2000 and Oracle 8.0.5
Goto Forum:
  


Current Time: Fri Sep 30 05:29:55 CDT 2016

Total time taken to generate the page: 0.11992 seconds