OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Need Help (APEX 2.2)

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

Need Help [message #472807]

Tue, 24 August 2010 01:04

nagpalgggmailcom
Messages: 16
Registered: August 2010
Location: Bangalore

Junior Member

Hi All,

Kindly help as i am new to this development tool( APEX2.2)

I created two item named value1,value2 of textfied type (page item) which is database number column,My task is if user enter any numberic values in these two column then values should insert into table else null means if user will not enter any value.

Thanks in advance.
Regards
gn

Report message to a moderator

Re: Need Help [message #472828 is a reply to message #472807]

Tue, 24 August 2010 02:11

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Have a look at this link below:

http://apps2fusion.com/apps-training/oracle-application-express-apex

You will find 3 links there which should be helpful for you.

They are:
Oracle APEX - Person Details Tutorial 03 (Create and Update Person)
Oracle APEX - Person Details Audio Video Tutorial 01 (Search Page)
Oracle APEX - Person Details Tutorial 02 (Delete functionality)

Regards
Ved

Report message to a moderator

Re: Need Help [message #473002 is a reply to message #472828]

Wed, 25 August 2010 06:07

nagpalgggmailcom
Messages: 16
Registered: August 2010
Location: Bangalore

Junior Member

Can you guide me releated to coding point of view?
thanks for the documents..

Report message to a moderator

Re: Need Help [message #473154 is a reply to message #473002]

Thu, 26 August 2010 05:50

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Have a look at http://deneskubicek.blogspot.com , There is a link for demo application.You will find lots of examples there.
Also you can have a look at this link

Regards
Ved

[Updated on: Thu, 26 August 2010 05:53]

Report message to a moderator

Re: Need Help [message #473238 is a reply to message #473154]

Thu, 26 August 2010 16:09

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

Senior Member
Account Moderator

Quote:

My task is if user enter any numberic values in these two column then values should insert into table else null means if user will not enter any value.

But, if user enters "nothing", there's nothing to be saved so - you don't have to do anything.

Or did I misread the question?

Report message to a moderator

Re: Need Help [message #475762 is a reply to message #472807]

Fri, 17 September 2010 07:11

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

You need to write javascript code for event onkeypress/onblur.
You have to check keyed in value over there by its ASCII value.

Or you can create one apex process which will check whole inserted data character by character that all the characters are numeric values. Else you set item value to null/blank.

regards,
Delna

Report message to a moderator

Re: Need Help [message #475963 is a reply to message #475762]

Mon, 20 September 2010 01:34

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

Create a validation process in the Page Processing section of the page you are creating (In edit mode) and make it conditional for the items to be numeric value.Oracle apex provides the functionality for validation of item.

Or, can think of creating a java script function for validation. isNaN() function could be useful.

Regards
Ved

Report message to a moderator

Re: Need Help [message #477449 is a reply to message #475963]

Thu, 30 September 2010 12:46

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

hi,

Considering OP's request writing simple check constraint or trigger may help

dr.s.raghunathan

Report message to a moderator

Previous Topic:	Page protect (?) in an SQL report
Next Topic:	shuttle box

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 31 07:47:41 CDT 2023