Automaticlly running a query [message #81483] |
Sat, 22 February 2003 04:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
CreativePresence
Messages: 73 Registered: December 2002
|
Member |
|
|
Another question from me - I have a text item within 1 datablock called "Project" that i use to enter a query value via a LOV or manually entering the value of 3 character (GBR) & then 3 numerical values. But now i want a triger or something to run the query automaticlly, saving the need to press a query button once 6 characters have been entered into the text item & then if records are found move the cursor to another datablock to enable the user to insert some data. Can this be done? if so, how?
All assistance welcome, Thanks in advance.
|
|
|
Re: Automaticlly running a query [message #81522 is a reply to message #81483] |
Wed, 26 February 2003 22:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Avinash Pai
Messages: 23 Registered: February 2003
|
Junior Member |
|
|
hi CreativePresence !!!
1. set the maximum length property of ur field (used to query) to 6 ,
2. write
do_key('execute_query');
in the "WHEN-NEW-ITEM-INSTANCE" trigger of a navigable item which is next to ur field (used to query).
best regards,
avinash pai
|
|
|
|