Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Need Help (APEX 2.2)
Need Help [message #472807] Tue, 24 August 2010 01:04 Go to next message
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
Re: Need Help [message #472828 is a reply to message #472807] Tue, 24 August 2010 02:11 Go to previous messageGo to next message
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
Re: Need Help [message #473002 is a reply to message #472828] Wed, 25 August 2010 06:07 Go to previous messageGo to next message
nagpalgggmailcom
Messages: 16
Registered: August 2010
Location: Bangalore
Junior Member
Can you guide me releated to coding point of view?
thanks for the documents..
Re: Need Help [message #473154 is a reply to message #473002] Thu, 26 August 2010 05:50 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Need Help [message #475762 is a reply to message #472807] Fri, 17 September 2010 07:11 Go to previous messageGo to next message
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
Re: Need Help [message #475963 is a reply to message #475762] Mon, 20 September 2010 01:34 Go to previous messageGo to next message
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
Re: Need Help [message #477449 is a reply to message #475963] Thu, 30 September 2010 12:46 Go to previous message
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
Previous Topic: Page protect (?) in an SQL report
Next Topic: shuttle box
Goto Forum:
  


Current Time: Thu Mar 28 16:14:33 CDT 2024