OraFAQ Forum: Forms » SET_BLOCK

Home » Developer & Programmer » Forms » SET_BLOCK_PROPERTY (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SET_BLOCK_PROPERTY [message #506616]

Tue, 10 May 2011 05:53

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

Report message to a moderator

Re: SET_BLOCK_PROPERTY [message #506632 is a reply to message #506616]

Tue, 10 May 2011 06:30

cookiemonster
Messages: 13967
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.

Report message to a moderator

Re: SET_BLOCK_PROPERTY [message #506672 is a reply to message #506632]

Tue, 10 May 2011 08:07

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.

Report message to a moderator

Re: SET_BLOCK_PROPERTY [message #506680 is a reply to message #506672]

Tue, 10 May 2011 08:34

cookiemonster
Messages: 13967
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.

Report message to a moderator

Re: SET_BLOCK_PROPERTY [message #506719 is a reply to message #506680]

Tue, 10 May 2011 15:19

Littlefoot
Messages: 21824
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".

Report message to a moderator

Previous Topic:	Help with Triggers V2
Next Topic:	rupee font

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 11 21:54:53 CDT 2025