Home » Developer & Programmer » Forms » No of detail block records.
No of detail block records. [message #201887] Tue, 07 November 2006 03:59 Go to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi Friends,
I have a Master-Detail block in which I need to display the number of records in the Detail block
displayed whenever I select the Master record.

Regards,
X.Marlon.
Re: No of detail block records. [message #201890 is a reply to message #201887] Tue, 07 November 2006 04:10 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I usually discourage this kind of functionality but if you have no choice you could have a look at summary fields.

MHE
Re: No of detail block records. [message #202016 is a reply to message #201890] Tue, 07 November 2006 21:28 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You could also use the 'count_query' command. Search this forum for 'count_query' I think I wrote somewhere where you need to issue the command as part of the 'pre-query', and certainly before the 'execute_query' otherwise the 'count_query' will retrieve ALL the records. This is not good when you are working with MANY rows.

David
Previous Topic: Insert sysdate on commit
Next Topic: login screen
Goto Forum:
  


Current Time: Wed Dec 07 07:06:58 CST 2016

Total time taken to generate the page: 0.13480 seconds