Re: forms6 - default value for date item

Add to your registry :

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
NLS_DATE_FORMAT='DD/MM/RRRR'

"Chris Kempster" <ckempste_at_iinet.com.au> a écrit dans le message news: 3b9cc3a3$0$18348_at_echo-01.iinet.net.au...
> Hi all
>
> I havent used forms for yonks, and am having some trouble with default
> values for a date item (column) for a data block. Basically the item is
of
> data type property "Date", ive set the format mask to DD/MM/YYYY. When I
> try to enter a value for the "initial value" property I get the error:
>
> FRM-11328 Initial value is invalid;correct format is DD/MM/YYYY
>
> Ive tried all sorts of combo's of to_date and to_char with no luck. All I
> wanted to do is put in the current system date as the default without
having
> to code a trigger.
>
> ideas?
>
> Cheers
>
> Chris
>
>
>
>
Received on Mon Sep 10 2001 - 16:00:15 CEST