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
|
|
|
|
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
|
|
|
|
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
|
|
|
Re: search form [message #324599 is a reply to message #324564] |
Tue, 03 June 2008 04:59 |
|
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 #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
|
|
|
|