Home » Developer & Programmer » Forms » Default WHERE String on New Form Instance
Default WHERE String on New Form Instance [message #78808] Mon, 18 March 2002 09:12 Go to next message
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 Go to previous message
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!!!
Previous Topic: Calling one for from another.
Next Topic: how can i make dynamic select
Goto Forum:
  


Current Time: Wed May 27 18:35:17 CDT 2020