Home » Developer & Programmer » Forms » HOW TO RESTRICT
HOW TO RESTRICT [message #242698] Mon, 04 June 2007 13:23 Go to next message
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
Re: HOW TO RESTRICT [message #242712 is a reply to message #242698] Mon, 04 June 2007 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: HOW TO RESTRICT [message #243815 is a reply to message #242698] Sat, 09 June 2007 04:25 Go to previous messageGo to next message
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');
Re: HOW TO RESTRICT [message #245351 is a reply to message #243815] Sat, 16 June 2007 05:15 Go to previous message
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
Previous Topic: FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001.
Next Topic: built-in callendar
Goto Forum:
  


Current Time: Sun Dec 04 23:00:24 CST 2016

Total time taken to generate the page: 0.09077 seconds