| Capture Key press in Oracle Forms [message #460696] |
Mon, 14 June 2010 04:36  |
mary.yujin
Messages: 26
Registered: June 2010
|
Junior Member |
|
|
Hi All,
Please advise me how to capture key press in oracle forms 6i.My intention is to create a form with 2 blocks. First block have one text item which user will input data and second block displays data based on the value typing in the text item(Same like LOV).
Mary Yujin
|
|
|
|
|
|
|
|
| Re: Capture Key press in Oracle Forms [message #460717 is a reply to message #460708] |
Mon, 14 June 2010 05:09  |
cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
m4yujin wrote on Mon, 14 June 2010 11:04Thanks,
But actualy my second blocks displays all the data in alphabetical order.
I really can't see why that's a problem.
m4yujin wrote on Mon, 14 June 2010 11:04
Still it is very difficult to search a particular record as the block displays more than 500 records.
Do you understand how oracle's search functionality works?
If you use enter-query mode and enter search criteria you will only get back as many records as match that criteria.
m4yujin wrote on Mon, 14 June 2010 11:04I have attached excel sheet.
Where?
|
|
|
|
|
|
|
|
| Re: Capture Key press in Oracle Forms [message #460728 is a reply to message #460724] |
Mon, 14 June 2010 05:25 |
mary.yujin
Messages: 26
Registered: June 2010
|
Junior Member |
|
|
Yes,
But thing is that user dont want to click/press on any key before or after typing the name in upper block.While typing name in text item in upper block itself, automatically the below block should display data starting with name mentioned in upper text item and user will put tick mark against the name they want.
Thanks in advance.
|
|
|
|
|
|
|
|
| Re: Capture Key press in Oracle Forms [message #460752 is a reply to message #460737] |
Mon, 14 June 2010 06:24 |
 |
Littlefoot
Messages: 21817
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
A form, itself, is unaware that someone is typing characters into an item, until you navigate out of that item. Then the WHEN-VALIDATE-ITEM or POST-TEXT-ITEM triggers fire (if they exist) (perhaps some other triggers too).
If you know Java, you could try to implement solution that includes both Forms and Java (I don't know how to do that).
Or, you could use another tool (different from Oracle Forms).
Or, if you still want Forms, there is a way to "simulate" your requirement (not entirely, but close enough).
When user enters "Ba" into the search item, he/she will have to press <Tab> or <Enter> which will fire KEY-NEXT-ITEM trigger.
In that trigger, you'd have to modify details block property by using the SET_BLOCK_PROPERTY built-in. It should set ONETIME_WHERE clause so that query would return all 'Ba%' (which means that you'll have to use a wildcard).
Finally, go to the detail block (GO_BLOCK) and EXECUTE_QUERY. Don't forget to set the default ORDER BY clause for that block.
For more information about the above, search the board - there've been examples of how to do that.
[Updated on: Mon, 14 June 2010 06:25] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
