Home » Developer & Programmer » Application Express & MOD_PLSQL » VALIDATION IN APEX (ORACLE 11G, APEX)
VALIDATION IN APEX [message #554599] Tue, 15 May 2012 23:09 Go to next message
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

Re: VALIDATION IN APEX [message #554613 is a reply to message #554599] Wed, 16 May 2012 00:05 Go to previous messageGo to next message
Littlefoot
Messages: 19320
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).
Re: VALIDATION IN APEX [message #554614 is a reply to message #554613] Wed, 16 May 2012 00:20 Go to previous messageGo to next message
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
Re: VALIDATION IN APEX [message #554632 is a reply to message #554614] Wed, 16 May 2012 01:20 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I ran Page 1. The dynamic action seems to be working (you only need to navigate out of the QTY PCS1 item).

./fa/10159/0/

Does that mean that everything is OK, after all?
  • Attachment: pcs.png
    (Size: 20.81KB, Downloaded 205 times)
Re: VALIDATION IN APEX [message #554636 is a reply to message #554632] Wed, 16 May 2012 01:28 Go to previous messageGo to next message
mike.pilapil
Messages: 5
Registered: May 2012
Location: manila
Junior Member
YUP.. THATS ITS MASTER.. THANKS YOU SO MUCH..
Re: VALIDATION IN APEX [message #554637 is a reply to message #554636] Wed, 16 May 2012 01:29 Go to previous messageGo to next message
mike.pilapil
Messages: 5
Registered: May 2012
Location: manila
Junior Member
HOW DO YOU DO THAT MASTER?
Re: VALIDATION IN APEX [message #554639 is a reply to message #554637] Wed, 16 May 2012 01:37 Go to previous message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Like this:

./fa/10160/0/

  • Attachment: pcs_2.png
    (Size: 34.97KB, Downloaded 198 times)
Previous Topic: How to REJECT or APPROVE the request in APEX4.1
Next Topic: how to update the column in table based on the value selected in apex4.1
Goto Forum:
  


Current Time: Mon Jul 28 12:47:10 CDT 2014

Total time taken to generate the page: 0.16596 seconds