Home » Developer & Programmer » Forms » Automaticlly running a query
Automaticlly running a query [message #81483] Sat, 22 February 2003 04:40 Go to next message
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 messageGo to next message
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
Re: Automaticlly running a query [message #81536 is a reply to message #81522] Thu, 27 February 2003 16:14 Go to previous message
CreativePresence
Messages: 73
Registered: December 2002
Member
Thanks, i'll give that a try.
Regards,
Previous Topic: Patch for Developer 6i
Next Topic: FORMS 6I: UPDATE PROBLEM
Goto Forum:
  


Current Time: Fri Dec 03 07:58:08 CST 2021