Subhash

• Sep 1st, 2005

 

Using :system.last_query

venkat

• Sep 26th, 2005

 

How to see the select statement when we issue execute_query

Sumanth

• Oct 27th, 2005

 

Override key exeqry with :system.last_query

Venkata Ramana

• Sep 14th, 2006

 

Using Get_Block_Property('Block Name',LAST_QUERY); Built-in function we can see the query which is executed last in the form module.

vinod.pandit

 Profile Answers by vinod.pandit 

• Jul 1st, 2007

 

Using :system.last_query

bc_sumanamara

 Profile Answers by bc_sumanamara 

• Jan 12th, 2009

 

BY USING :SYSTEM.LAST_QUERY;
EXAMPLE
 WHEN-NEW-FORM-INSTANCE
BEGIN 
 execute_query;
MESSAGE(:SYSTEM,LAST_RECORD);
END;
RUN THE FORM...

bc_sumanamara

 Profile Answers by bc_sumanamara 

• Apr 3rd, 2009

 

Using :system.last_query