Re: Date, Format Masks and Maximum Length

I think that the problem is that the physical lenght of your field is 9. Change it to 11.
Item properties--> length
I hope it helps.
Mabel,

rgouldin <rgouldin_at_mail.usyd.edu.au> wrote in article <01bd2217$b72c06f0$b440cf96_at_utricularia>...
> I seem to have come across a problem with conversion of dates from the
> default form of DD-MON-YY to the form DD-MON-YYYY using Forms Designer
 V4.5
> for Windows NT V4.
>
> What is happening is this. I have base table item that is attached to a
> date field, now th I've changed the format mask in the Property sheet to
> the desired format, and also adjust the maximum length property to cope
> with these two extra characters.
>
> However, I can't compile and run it, because the database seems to be
> telling the form that the date column in base table has a maximum length
 of
> 9 characters, which is the length of the default DD-MON-YY.
>
> I know that it is not the database itself, since the column is defined as
> type DATE and this allows me to convert the date from a PL/SQL command
> into the format I want, so what am I doing wrong in the Forms Designer?
>
> Cheers
> Richard Goulding.
>
  Received on Sun Jan 18 1998 - 00:00:00 CET