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.

Report message to a moderator

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: 7065
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

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:37:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.