Home » Developer & Programmer » Forms » Displaying no of records dynamically for a block
Displaying no of records dynamically for a block [message #80881] Wed, 11 December 2002 05:34 Go to next message
Kumar Devendra
Messages: 4
Registered: June 2002
Junior Member
I want to display multiple records for a block based on some condition.To get the no of records displayed dynamically i want to set block property.But there is no property like "RECORDS_DISPLAYED" as in the case of "GET_BLOCK_PROPERTY".Plese help me.
I am using Developer 4.5 and ORACLE 7.1.4.
Re: Displaying no of records dynamically for a block [message #80923 is a reply to message #80881] Sat, 14 December 2002 08:15 Go to previous message
Piyush Balan
Messages: 26
Registered: December 2002
Junior Member
hi Kumar,
The only way to conditionally filter the no. of rows to be displayed is by setting the WHERE Clause in the block property. and this setting has to be in any trigger which fires before Query on the block excutes.
for eg. Pre-Query.
try it out and let me know the results.
regards,
Piyush Balan,
Consultant
Comsoft Pte. Ltd.
Singapore
Previous Topic: reports
Next Topic: reports
Goto Forum:
  


Current Time: Thu Mar 28 05:54:45 CDT 2024