Home » Developer & Programmer » Forms » Date field gets disabled when a date format is given (Oracle Forms,11g,windows server 2003)
Date field gets disabled when a date format is given [message #567539] Wed, 03 October 2012 04:03 Go to next message
rjocmc
Messages: 14
Registered: December 2011
Junior Member
A field named xxx_date is a text item which we have to enter manually so as to update a record in that particular date. This is a mandatory field without which we cannot continue the data entry..

I am getting this error while trying to update the record

FRM-40509 :Oracle error :unable to update record

I have kept the enabled = yes
required=no
data type=Date.. in the property pallet

Pls help..
Re: Date field gets disabled when a date format is given [message #567547 is a reply to message #567539] Wed, 03 October 2012 04:37 Go to previous messageGo to next message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Run the form again, enter the value. There'll be an error (of course). Now, go to Forms runtime HELP menu and choose "Display error". What's written in there?
Re: Date field gets disabled when a date format is given [message #567674 is a reply to message #567547] Thu, 04 October 2012 03:58 Go to previous message
rjocmc
Messages: 14
Registered: December 2011
Junior Member
Thanks for the acknowledgment

I have solved the error by dropping and recreating the date field. Now it is working fine without any flaws.


Previous Topic: list_item selection problem
Next Topic: transfer data from called form to calling form
Goto Forum:
  


Current Time: Thu Oct 30 11:20:21 CDT 2014

Total time taken to generate the page: 0.05620 seconds