OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » VALIDATION IN APEX (ORACLE 11G, APEX)

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

VALIDATION IN APEX [message #554599]

Tue, 15 May 2012 23:09

mike.pilapil
Messages: 5
Registered: May 2012
Location: manila

Junior Member

GOOD DAY MASTER

I HAVE 2 TEXTFIELD QTY_PCS1 AND QTY_LEFT1 THEY ARE INTEGER
WHAT I WANT TO DO IS IF THE USER INPUT IN QTY_PCS1 GREATER THAN THE VALUE OF QTY_LEFT
IT WILL COME A ERROR MESSAGE.

IN MY CASE THE VALUE OF QTY_PCS1 IS COMING FROM DATABASE

I HAVE A POPUP LOV (ITEM_NAME) THAT COMING TO DATABASE VIEW
UNDER THAT POPUP LOV I CREATED A DYNAMIC ACTION (SET VALUE)
WHERE WHEN THE USER CLICK THE POPUP LOV(ITEM_NAME) AND PICK A ITEM
IT WILL SET VALUE OF QTY_LEFT1 TO THAT CORRESPONDING ITEM NAME.

AND AFTER THAT I TRY TO INPUT TO QTY_PCS1 THE DYNAMIC ACTION(ALERT IN QTY_PCS1)
IT'S NOT WORKING ANYMORE.. ITS ONLY WORKING ONLY WHEN THE QTY_LEFT1 HAVE A DEFAULT VALUE..

IF THERE'S A WAY FOR ME TO DO IT??

HERE IS THE LINK OF SAMPLE APPLICATION FOR YOU TO VIEW MASTER

HOPE YOUR RESPONDS AND THANKS IN ADVANCE

Report message to a moderator

Re: VALIDATION IN APEX [message #554613 is a reply to message #554599]

Wed, 16 May 2012 00:05

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

Senior Member
Account Moderator

Quote:

IT'S NOT WORKING ANYMORE

Does it mean that it used to work, but now it does not? If so, what improvement did you apply? Can you revert it back? (Possibly restore it from the backup?)

Did you correctly set the dynamic action?

Run the page in Debug mode and see what information it presents - maybe you'll figure it out.

Quote:

HERE IS THE LINK ...

There's no link in your message. I know, you aren't allowed to post links until you reach 5 messages, but - you'll figure it, somehow (for example, use hxxp instead of http).

Report message to a moderator

Re: VALIDATION IN APEX [message #554614 is a reply to message #554613]

Wed, 16 May 2012 00:20

mike.pilapil
Messages: 5
Registered: May 2012
Location: manila

Junior Member

sorry for that
workspace : testing_only
username : guest1
pass : goldenPM

and here is the login form

X://apex.oracle.com/pls/apex/f?p=4550:1:0:::::
please help me on this..

the application name is dynamic_action

PLEASE CHANGE X TO HTTP

THANKS FOR THE RESPONDS

Report message to a moderator