OraFAQ Forum: Forms » Filter the records displayed in Form

Home » Developer & Programmer » Forms » Filter the records displayed in Form

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

Filter the records displayed in Form [message #455496]

Tue, 11 May 2010 20:36

coolguy01
Messages: 64
Registered: August 2006

Member

Hi,
I have a block in the form which is based of a table as data source and so when i query on the form using a execute_query inbuilt statement is fired and all the records in the table behind is retrived and displayed. Also if i need to update any record i can do in on the screen and use commit_form so that all the changes go into the underlying table. Now my problem is when i retrieving my records i want to filter those records based on some conditions to be displayed in the form and not all records to be retrieved. Is it possible to do it if I am using the execute_query inbuilt and my block is based of a table?

Thanks and Regards

Report message to a moderator

Re: Filter the records displayed in Form [message #455524 is a reply to message #455496]

Wed, 12 May 2010 01:03

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Press <Enter query>.
Enter search criteria (in order to filter records) (for example, "coolguy01" into the "name" item)
Press <Execute query>

Report message to a moderator

Re: Filter the records displayed in Form [message #455748 is a reply to message #455524]

Wed, 12 May 2010 14:50

coolguy01
Messages: 64
Registered: August 2006

Member

I understand the enter query and execute query mode on forms but I need to enter the search criterias in the block above and after the iexecute the query display the results in the block below.

Report message to a moderator

Re: Filter the records displayed in Form [message #455749 is a reply to message #455748]

Wed, 12 May 2010 15:41

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why, what are you trying to achieve?
Setting the onetime_where poperty might be what you want.

Report message to a moderator

Re: Filter the records displayed in Form [message #455765 is a reply to message #455749]

Wed, 12 May 2010 21:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What's wrong with putting something in the 'ORDER BY Clause' block property?

David

Report message to a moderator

Re: Filter the records displayed in Form [message #455877 is a reply to message #455765]

Thu, 13 May 2010 04:28

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

What's order by got to do with this?

Report message to a moderator

Re: Filter the records displayed in Form [message #455910 is a reply to message #455877]

Thu, 13 May 2010 07:15

ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester

Member

I think you can set the "Where Clause" property of BLOCK while run time.

Report message to a moderator

Re: Filter the records displayed in Form [message #455960 is a reply to message #455910]

Thu, 13 May 2010 15:37

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what Cookiemonster said, isn't it?

Report message to a moderator

Re: Filter the records displayed in Form [message #455986 is a reply to message #455960]

Thu, 13 May 2010 23:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I thought the OP had an order problem because they had certainly been given all the assitance with the 'where' bits and peices that they could possibly need.

David

Report message to a moderator

Previous Topic:	run adobe acrobat in client side using 10g
Next Topic:	Poor Performance in Accessing Remote Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:57:58 CDT 2024