| Default WHERE String on New Form Instance [message #78808] |
Mon, 18 March 2002 09:12  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
I have a new-form-instance trigger on a form with the following code...
DECLARE
WHERE_STRING VARCHAR2(200);
BEGIN
GO_BLOCK('PRODUCT_FEATURE_MEASURE');
WHERE_STRING := 'WHERE PRDM_PRFE_APFE_CODE = '||'''' ||:PARAMETER.P_APFE_CODE||''''||'AND PRDM_PRFE_PRCL_PRDT_CODE ='||'''' ||
:PARAMETER.P_PRDT_CODE||''''||'AND PRDM_PRFE_PRCL_CLAS_CODE ='||'''' ||
:PARAMETER.P_CLAS_CODE||''''||'AND
PRDM_APFM_CODE ='||'''' ||:PARAMETER.P_APFM_CODE;
SET_BLOCK_PROPERTY('PRODUCT_FEATURE_MEASURE',DEFAULT_WHERE,WHERE_STRING);
execute_query;
end;
-- The Problem is that the populated items on the form from this where string don't seem to be populating for the "where" clause, but instead...the first record in the table???HELP!
T
|
|
|
|
| Re: Default WHERE String on New Form Instance [message #78816 is a reply to message #78808] |
Mon, 18 March 2002 23:44  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
1. is :PARAMETER.xyz... are populated , it may be by passing the value from another form or populating in pre-form.
2.make sure the where clause is fine. try to print the WHERE_STRING and see if u have missed any space , u may try this where clause in sql plus.
most probably one of these two is the problem.
good luck!!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
