OraFAQ Forum: Forms » search form

Home » Developer & Programmer » Forms » search form

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

search form [message #79838]

Wed, 17 July 2002 19:02

aditya
Messages: 36
Registered: March 2001

Member

HI FRIENDS

I WANT TO MAKE A SEARCH FORM IN WHICH A LIST IS DISPLAYED CONTAING ALL COLUMNS(FIELDS)OF A PERTICULAR TABLE USER CAN SELECT ONE OR MORE FIELDS FROM THAT LIST AND ON BASIS OF THESE SELECTED FIELDS A NEW CANVAS SHOULD APPEAR WHICH CONTAING TEXTBOXES ONE FOR EACH SELECTED FIELDS........FOR EXAMPLE IF USER SELECT COMPANY,CITY,STATE THAN IN A NEW CANVAS THREE TEXTBOX SHOULD APPEAR IN WHICH USER CAN ENTER VALUE ON THE BASIS OF WHICH HE/SHE WANTS TO SEARCH SOME THING...PLZ SUGGEST ME ANY LOGIC
AD

Report message to a moderator

Re: search form [message #79841 is a reply to message #79838]

Wed, 17 July 2002 21:20

Ravi
Messages: 251
Registered: June 1998

Senior Member

On the basis of selection ... chage the where clause(default_where) of your block in which you will show the records.

Report message to a moderator

Re: search form [message #79854 is a reply to message #79838]

Thu, 18 July 2002 08:03

aditya
Messages: 36
Registered: March 2001

Member

hi ravi
thanx 4 reply.......ok i will in set default_where in set block property
but how can i select multiple items in a list and how can i create a textboxes at run time.......some times may be user select only one fields and another time he may be select 4 or more fields.....i want to give freedom to user to select fields of his choice for search criteria........
ad

Report message to a moderator

Re: search form [message #79862 is a reply to message #79838]

Thu, 18 July 2002 20:49

Ravi
Messages: 251
Registered: June 1998

Senior Member

Hi Aditya

You need not to create text_items and other items at runtime.
At runtime only make them visible and unvisible as per user selection. And change the position alo if required.

Report message to a moderator

Re: search form [message #82453 is a reply to message #79838]

Wed, 28 May 2003 04:09

Hemant Matai
Messages: 10
Registered: May 2003

Junior Member

HI FRIENDS
I WANT TO MAKE A Search Form IN WHICH A LIST IS DISPLAYED CONTAING ALL COLUMNS(FIELDS)OF A PERTICULAR TABLE USER CAN SELECT ONE OR MORE FIELDS FROM THAT LIST AND ON BASIS OF THESE SELECTED FIELDS A NEW CANVAS SHOULD APPEAR WHICH CONTAING TEXTBOXES ONE FOR EACH SELECTED FIELDS........FOR EXAMPLE IF USER SELECT COMPANY,CITY,STATE THAN IN A NEW CANVAS THREE TEXTBOX SHOULD APPEAR IN WHICH USER CAN ENTER VALUE ON THE BASIS OF WHICH HE/SHE WANTS TO Search SOME THING...PLZ SUGGEST ME ANY LOGIC

Report message to a moderator

Previous Topic:	Doubt in No Generation
Next Topic:	insert a gif picture in push button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 02:04:01 CDT 2024