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..

Report message to a moderator

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: 21813
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?

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 02:45:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.