Home » Developer & Programmer » Forms » SET_BLOCK_PROPERTY (oracle 10g)
SET_BLOCK_PROPERTY [message #506616] Tue, 10 May 2011 05:53 Go to next message
swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai
Member
Hi all,

can i get an idea about SET_BLOCK_PROPERTY where in i am entering a number in a textbox and respected number of rows should be displayed.

is it possible to set this property dynamically

Waiting for reply

Swapnil

Re: SET_BLOCK_PROPERTY [message #506632 is a reply to message #506616] Tue, 10 May 2011 06:30 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you read the form builder help topic on set_block_property?
It lists all the properties that can be set.
Re: SET_BLOCK_PROPERTY [message #506672 is a reply to message #506632] Tue, 10 May 2011 08:07 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Actually cookiemonster, I have no idea what he is asking, although I dot think he wants to know what parameters SET_BLOCK_PROPERTY takes.

What are respected number of rows? If you remove the word "respected" it still does not make sense. Enter a number into a field and show the number of rows. From what? What rows? What condition? Entry mode? Query mode? I really have no idea.
Re: SET_BLOCK_PROPERTY [message #506680 is a reply to message #506672] Tue, 10 May 2011 08:34 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
The help topic lists which properties of a block set_block_property can change, So regardless of what they are trying to accomplish with it and answer will be there.
I assume they want to alter either:
Number of records displayed
or
Query array size

Either way the answer is no.
Re: SET_BLOCK_PROPERTY [message #506719 is a reply to message #506680] Tue, 10 May 2011 15:19 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When I see such an (unclear) question that talks about "number of records in a block", I always think that it is about number of records displayed in a tabular block. You know ... when creating a block, you set it to display 10 records. Now you run a form, perform query that returns 7 records. So you'd want to dynamically change that "10" records to "7" (i.e. hide three last, empty records (actually, items) from the screen).

If that's the question, the answer would still be "No, you can't do that".
Previous Topic: Help with Triggers V2
Next Topic: rupee font
Goto Forum:
  


Current Time: Sat Sep 07 15:25:05 CDT 2024