problems with ENTER_QUERY, EXECUTE_QUERY
446714Oct 9 2005 — edited Oct 11 2005Hi I'm having a problem with my form. I have a button which needs to perform an ENTER_QUERY, get a value from an LOV, and then do an EXECUTE_QUERY. The problem is that the ENTER_QUERY doesn't appear to do anything, so when the EXECUTE_QUERY runs, it just pulls all the records out instead of just the one I want.
Another thing I want to do is be able to do a Cancel Query using PL/SQL, but I can't find the command for it anwhere.
any help appreciated
adam