| EXECUTE_QUERY.........save? [message #79434] |
Mon, 10 June 2002 12:30  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
Hello All,
The issue is that... I have a when window activated trigger that executes_query with a global variable in the where_string. But before the query executes, it asks you if you'd like to save, even though nothing has been changed... I don't want the form to ask that. How do I get around this?
Tyler
|
|
|
|
|
|
| Re: EXECUTE_QUERY.........save? [message #79481 is a reply to message #79441] |
Thu, 13 June 2002 11:04  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
Thanx for replying, I have tried to use the clear_block('no_validate'); (shown in my code below). But it won't execute. It doesn't ask me to save anymore, but now it doesn't execute... that's why I've commented out that line below, but it again asks to save.
DECLARE
WHERE_STRING VARCHAR2(230);
V_CODE NUMBER := NAME_IN('NAME_LST');
BEGIN
SELECT PRDT_NAME INTO :PRDT_NAME FROM PRODUCT WHERE
PRDT_CODE = V_CODE;
GO_BLOCK('PRODUCT');
WHERE_STRING := 'WHERE PRDT_code = '||''''||V_CODE||'''';
SET_BLOCK_PROPERTY('PRODUCT',DEFAULT_WHERE,WHERE_STRING);
--CLEAR_BLOCK('NO_VALIDATE');
EXECUTE_QUERY;
END;
|
|
|
|
| also [message #79482 is a reply to message #79441] |
Thu, 13 June 2002 12:14 |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
|
I just took off the on-error trigger, so I realized that I'm getting the error ORA-06502 when I try to execute the query with clear_block('no_validate') which means data conversion error. This is caused by the no validate.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
