Re: Date funny in SQL*Forms 3.0

In article <17JAN199415050775_at_erich.triumf.ca>, Peter A. Grant <grant_at_erich.triumf.ca> wrote:
>
>A strange bug has crept into one of my forms which I don't really understand.
>A field is defined to be a DATE - a DATETIME in Forms. Almost always
>repeatable, the day, year, and time are all updatable, but if you change the
>month, it magically changes back to what it was when you leave the field or
>commit the record.
>
>I ran it in debug mode and there weren't any triggers reported as being
>fired. Pretty odd. Any bright ideas?
>

It could be a problem with usage of the mask format. Especially, make sure you don't specify 'MM' for the minutes part of the format.   

Mirek Piaseczny
mirek_at_unixg.ubc.ca Received on Tue Jan 18 1994 - 19:58:03 CET