OraFAQ Forum: Forms » search form

Home » Developer & Programmer » Forms » search form (forms 6i/ oracle 8i/windows2000) (

) 1 Vote

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

search form [message #324387]

Mon, 02 June 2008 04:51

conversing
Messages: 15
Registered: April 2006
Location: pakistan

Junior Member

hi gurus
say i have a datablock containing data regarding books. i want to search datablock,say, on more than one ISBNs simultaneously. for example i may give 5 ISBNs and to reply me available details of books having those ISBNs. hope i represent my problem clearly.

regards

asif iqbal

Report message to a moderator

Re: search form [message #324394 is a reply to message #324387]

Mon, 02 June 2008 05:16

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

Senior Member
Account Moderator

Here are the steps:

enter query mode
go to ISBN item
type ":a" (without double quotes; it doesn't have to be "a", it may be anything valid, such as ":isbn". Colon (:) indicates that you'd like to perform an "advanced" search)
another window will open; enter all of these ISBNs in the form used in WHERE clause:
```
:a in ('Little', 'Foot', 'Large')
```
execute query

Here's how it looks like (disregard the fact that it is localized to Croatian language)

/forum/fa/4384/0/

[EDIT: disabled smilies]

Attachment: advanced_query.PNG
(Size: 5.09KB, Downloaded 896 times)

[Updated on: Mon, 02 June 2008 05:17]

Report message to a moderator

Re: search form [message #324538 is a reply to message #324394]

Tue, 03 June 2008 00:49

conversing
Messages: 15
Registered: April 2006
Location: pakistan

Junior Member

thank you very much for the solution. but i have a problem, i don't want end user to manually do all the procedure.i want user to enter ISBNs say in a textbox etc and then only press button, all procedure should be done at backend programatically.

regards

asif iqbal

Report message to a moderator

Re: search form [message #324548 is a reply to message #324538]

Tue, 03 June 2008 01:52

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

Senior Member
Account Moderator

Quote:

all procedure should be done at backend programatically

Fine with me; please, start coding. Once you have a question about a specific problem, do return and explain what you did and why it doesn't work as expected (including code, error messages etc.).

Report message to a moderator

Re: search form [message #324564 is a reply to message #324548]

Tue, 03 June 2008 02:55

conversing
Messages: 15
Registered: April 2006
Location: pakistan

Junior Member

thanks again
can u give me an idea how to assign a list of ISBNs in enter-query mode programetically??

regards

asif iqbal

Report message to a moderator

Re: search form [message #324599 is a reply to message #324564]

Tue, 03 June 2008 04:59

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Create One more Block as Whatever u name it I name it as Button Block . Place a Search Field Called :P_BOOK_NAME

Write a Key-Next Trigger

set_block_property('BOOK_MASTER', default_where, 
		 			'BOOK_ID LIKE decode(:P_BOOK_NAME,''%'',BOOK_ID, :P_BOOK_NAME||''%''));

Jak

Report message to a moderator

Re: search form [message #324601 is a reply to message #324599]

Tue, 03 June 2008 05:01

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Place the Serch Feild on the Same canvas of your Data Grid.

Attachment: 1.JPG
(Size: 16.08KB, Downloaded 430 times)

Report message to a moderator

Re: search form [message #324871 is a reply to message #324601]

Wed, 04 June 2008 06:53

conversing
Messages: 15
Registered: April 2006
Location: pakistan

Junior Member

hi,
thanks for all the guidence. i have done my needful. now i want to export data into an excel sheet. say i want to export emp table to an excel sheet where deptno is 10. what is the solution??

thanx in anticipation.

regards

asif iqbal

Report message to a moderator

Re: search form [message #335383 is a reply to message #324871]

Tue, 22 July 2008 00:57

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

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	Moving ScrollBar at runtime
Next Topic:	GROUP BY BLOCK ON FORM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 06:45:35 CDT 2024