OraFAQ Forum: Forms » HOW TO RESTRICT

Home » Developer & Programmer » Forms » HOW TO RESTRICT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO RESTRICT [message #242698]

Mon, 04 June 2007 13:23

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

HI EVERYONE,
IN A CODE WRITTEN IN FORMS6i
ON THE TAB BUTTON A LIST IS POPULATED ( COMBO TYPE LIST--MANDATOY CONDITION )
NOW THERE CAN BE MORE THAN ONE VALUE IN A LIST ITEM BUT IF THE VALUE IS NOT ONE OF THE VALUES OF POPULATED LIST THEN THE CURSOR SHOULD STOP NAVIGATION WITH AN ALERT........

AND THE SECOND PROBLEM IS TO ERASE THE GLOBAL VARIABLE

ALREADY TRIED CODE ARE :-

ERASE(:GLOBAL.VARIABLE);
                          ERASE (GLOBAL.VARIABLE);
                          ERASE ('GLOBAL.VARIABLE);
                          ERASE (':GLOBAL.VARIABLE);

NO ONE IS GIVING THE REQUIRED RESULT.....

REGARDS
RAJAT CHAUDHARY

Report message to a moderator

Re: HOW TO RESTRICT [message #242712 is a reply to message #242698]

Mon, 04 June 2007 15:13

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

Senior Member
Account Moderator

What made you type all the message in capital letters? Do you not know that it is considered impolite in Internet communication?

Furthermore, how come you still didn't discover Forms Online Help System? It contains the ERASE Built-in description, along with an example of how to properly use this procedure. But I agree that not one of your posted examples worked - none is written correctly. The right way to do that is

ERASE('global.variable_name');

Combo something? Sorry, I wouldn't know.

Report message to a moderator

Re: HOW TO RESTRICT [message #243815 is a reply to message #242698]

Sat, 09 June 2007 04:25

hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE

Senior Member

For your first question.
When u want to put such a restriction use POPLIST and not COMBOBOX.
If you do want to use a COMBOBOX, there is no property that will do the required on its own. you will have to write an exception code in the WHEN-VALIDATE-ITEM of the item. If you want it to run instantly on selection of a list option write the following code in the WHEN-LIST-CHANGED of the item

VALIDATE(item_scope);
IF NOT form_success THEN
   RAISE form_trigger_failure;
END IF;

For your second question
it has to be writted as :

ERASE('global.variable_name');

Report message to a moderator

Re: HOW TO RESTRICT [message #245351 is a reply to message #243815]

Sat, 16 June 2007 05:15

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

hi hemavb,
thansks very much for ur reply .
i have read it out , it looks that it works properly
if i again not get reqired result then i will intimate u.
BY THE WAY THENKS AGAIN !!!!!!!!!!!!!1

REGARDS
RAJAT CHAUDHARY

Report message to a moderator

Previous Topic:	FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001.
Next Topic:	built-in callendar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 08:35:33 CST 2024