OraFAQ Forum: Forms » Form-alert

Home » Developer & Programmer » Forms » Form-alert (oracle 10g Forms, windows 7)

Thu, 20 June 2013 13:37

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

in data block... in empno text item.. I created trigger using When-Validate-Item
in that pl/sql block I written this code

 
declare
	BTN number;
begin
	if length(:emp.EMPNO)<4 THEN
		BTN :=SHOW_ALERT('ALERT2');
	END IF;
END;

but it is not showing the alert message when enter the empno more than 4 letters.

i used Pre-Text-Item also....

Thanks & Regards,
The Learner.

[Updated on: Thu, 20 June 2013 13:40]

Thu, 20 June 2013 16:14

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

if length(:emp.EMPNO)<4 THEN BTN :=SHOW_ALERT('ALERT2');

vs.
Quote:

but it is not showing the alert message when enter the empno more than 4 letters.

Really, I wonder why? Man, do you READ & UNDERSTAND what you are doing? I don't think so (but that's just my opinion).

Fri, 21 June 2013 09:53

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Its my fault.

sorry.... Sad

Previous Topic:	Import Data from Excel to Oracle Forms
Next Topic:	when radio chenged trigger problem [merged 2 by jd]

Goto Forum:

]

Current Time: Tue Apr 16 13:02:49 CDT 2024