Home » Developer & Programmer » Forms » FRM-50011: Not a valid month name
FRM-50011: Not a valid month name [message #433773] Fri, 04 December 2009 03:54 Go to next message
boyet-x
Messages: 23
Registered: August 2006
Junior Member
Hi guys,

I have a non-updateable, non-database date field with format mask DD/MM/YYYY but it keeps raising this error. It was populated in a pll procedure using
Copy(to_char(v_date_var, 'DD/MM/YYYY'), 'block.date_item');

When I try to catch the value in On-error trigger using Name_in(:system.trigger_item), it shows valid value (e.g. 04/06/2009). What am I missing here?

Hope someone could help.
Btw, I'm using Forms 10G.

TIA.
Re: FRM-50011: Not a valid month name [message #433774 is a reply to message #433773] Fri, 04 December 2009 04:05 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
what's the datatype of v_date_var and block.date_item?
Re: FRM-50011: Not a valid month name [message #433776 is a reply to message #433774] Fri, 04 December 2009 04:13 Go to previous messageGo to next message
boyet-x
Messages: 23
Registered: August 2006
Junior Member
they are both date. Thanks.
Re: FRM-50011: Not a valid month name [message #433791 is a reply to message #433776] Fri, 04 December 2009 05:11 Go to previous messageGo to next message
paddu_1417
Messages: 1
Registered: July 2009
Junior Member
check the date format of block.date_item
Re: FRM-50011: Not a valid month name [message #433804 is a reply to message #433776] Fri, 04 December 2009 05:53 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
boyet-x wrote on Fri, 04 December 2009 11:13
they are both date. Thanks.

If both of them are DATE, why do you use TO_CHAR?
Previous Topic: How to Convert Currency value to Words
Next Topic: How to execute query in Enter Query mode programmaticaly?
Goto Forum:
  


Current Time: Fri Sep 20 09:43:30 CDT 2024