How to see the select statement when we issue execute_query

Using :system.last_query

How to see the select statement when we issue execute_query

Override key exeqry with :system.last_query

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

Using :system.last_query

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

Using :system.last_query