Home » Developer & Programmer » Forms » see my code for execute_query
see my code for execute_query [message #165754] Sat, 01 April 2006 05:35 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
hi master

sir i have two block one emp and other control block my button in control block

when i press enter query button then clear all text box and work fine see code

go_block('emp');
ENTER_QUERY;


when i give value such as 20 in deptno textbox and press execute_qury button the system not give any result and still in deptno textbox see execute button code

If :System.Mode = 'ENTER-QUERY' Then
If :emp.deptno is Not Null Then
go_block('emp');
EXECUTE_QUERY;
End If;
End If;

please give me idea

thanking you

Aamir

Re: see my code for execute_query [message #165857 is a reply to message #165754] Mon, 03 April 2006 02:21 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Make your 'execute' button non-navigable. Just have execute_query in your 'execute' trigger. Did it work?

David
Previous Topic: not show record after clear_form(no_validate)
Next Topic: how use search option in my form
Goto Forum:
  


Current Time: Fri Sep 20 04:29:34 CDT 2024