Home » Developer & Programmer » Forms » search form (forms 6i/ oracle 8i/windows2000)  () 1 Vote
search form [message #324387] Mon, 02 June 2008 04:51 Go to next message
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
Re: search form [message #324394 is a reply to message #324387] Mon, 02 June 2008 05:16 Go to previous messageGo to next message
Littlefoot
Messages: 21823
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]

[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 Go to previous messageGo to next message
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
Re: search form [message #324548 is a reply to message #324538] Tue, 03 June 2008 01:52 Go to previous messageGo to next message
Littlefoot
Messages: 21823
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.).
Re: search form [message #324564 is a reply to message #324548] Tue, 03 June 2008 02:55 Go to previous messageGo to next message
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
Re: search form [message #324599 is a reply to message #324564] Tue, 03 June 2008 04:59 Go to previous messageGo to next message
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

Re: search form [message #324601 is a reply to message #324599] Tue, 03 June 2008 05:01 Go to previous messageGo to next message
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 497 times)
Re: search form [message #324871 is a reply to message #324601] Wed, 04 June 2008 06:53 Go to previous messageGo to next message
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
Re: search form [message #335383 is a reply to message #324871] Tue, 22 July 2008 00:57 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

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


Current Time: Thu Dec 26 15:17:15 CST 2024