GoodHands_Delphi
asked on
updating error FRM-40401- Oracle Form6i
hi,
Block = up_f
button = btn_update
Oralce form6i
I have a block named up_f having fields of UPL_STT which has value of 'ERR', i have set my
block to display 10 records..i want to update UPL_STT to value of 'SENT' by clicking btn_update...an error occured " FRM-40414 : No changes to save" here is my script...
Note:
Disregard the parameters...
************************** *
BEGIN
UPDATE UP_F
SET UPL_STT = 'SENT'
WHERE TASK = 'LDIV' AND
UPL_STT = 'ERR' AND
TRAILER = 'LR88' AND
SKU = 'T23133';
IF (v_lst_trl_label = NULL OR v_lst_sku_label = NULL) THEN
RAISE Bad_Param;
ELSE
COMMIT;
END IF;
END;
**********************
any idea?
pls help...
regards....
Block = up_f
button = btn_update
Oralce form6i
I have a block named up_f having fields of UPL_STT which has value of 'ERR', i have set my
block to display 10 records..i want to update UPL_STT to value of 'SENT' by clicking btn_update...an error occured " FRM-40414 : No changes to save" here is my script...
Note:
Disregard the parameters...
**************************
BEGIN
UPDATE UP_F
SET UPL_STT = 'SENT'
WHERE TASK = 'LDIV' AND
UPL_STT = 'ERR' AND
TRAILER = 'LR88' AND
SKU = 'T23133';
IF (v_lst_trl_label = NULL OR v_lst_sku_label = NULL) THEN
RAISE Bad_Param;
ELSE
COMMIT;
END IF;
END;
**********************
any idea?
pls help...
regards....
FRM-40401: No changes to save - it is not an error, it just indicates that there are no changes in your block.
You can set
:system.message_level:='10 ';
and this message will not be displayed.
You can set
:system.message_level:='10
and this message will not be displayed.
Hi,
this is not an error message. IT'is an informational message. It says "you did not make any change so you do not need COMMIT". Are you sure about your update statement? It may not update any records? First try your update statement in sql*plus and be sure that it's correct.
this is not an error message. IT'is an informational message. It says "you did not make any change so you do not need COMMIT". Are you sure about your update statement? It may not update any records? First try your update statement in sql*plus and be sure that it's correct.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
we should accept your comment as correct answer. Because Concon's answer does not have a value for :SYSTEM.MESSAGE_LEVEL.
regards.
we should accept your comment as correct answer. Because Concon's answer does not have a value for :SYSTEM.MESSAGE_LEVEL.
regards.
hi
i think my response should be included in the assisted answers since it gives solution for the message which our friend is getting.
regards
annamalai
i think my response should be included in the assisted answers since it gives solution for the message which our friend is getting.
regards
annamalai
hi,
i am agree with annamalai and musdu.
regards.
i am agree with annamalai and musdu.
regards.
ok, i agree.
regards.
regards.
you could use this proc in order to bypass messages.
PROCEDURE commitwithoutmsg
vMessageLevel VARCHAR2(2);
BEGIN
vMessageLevel := Name_In('SYSTEM.MESSAGE_LE
Copy(CONSTANT.DISABLEMESSA
COMMIT;
Copy(vMessageLevel, 'SYSTEM.MESSAGE_LEVEL');
END;
regards.