Fw: Empty date

 Hi ,

 Thanks :-((
 My english knowledge is big handicap for exact explanation......, but


 For example :
 I have a table, that store a production progression .
 All progression schema is predefined respectively  for all different
 product .

 Example:
         Record      Step  Name                          Date (default =
null)
                    1.     Order
2005.01.10
                    2.     Order confirmation                2005.01.11
                    3.     Cutting
2005.01.12
                    4.     Painting
.
                    5.     Burning
.NULL.

 When starting a next step , then the date field change to empty ( from
 null ). The operator see the progression status in the screen.  The client
 program display empty value as 'in the pipeline' and display null values as
 ' remaining steps' .
 This is an example, but I use this way often (one field, in field a
standard or two or three special values  - more explanation  ) . In this way
I can display a plus information without a plus field.

 Hmmm..... My own stupidity..., but no problem ere now.

 Thanks again : Zoltan



> ----- Original Message -----
> From: "Richard Huxton" <dev@archonet.com>
> To: "Szmutku Zolt�n" <szmutku.zoltan@betet-kft.hu>
> Sent: Wednesday, March 30, 2005 1:01 PM
> Subject: Re: [GENERAL] Empty date
>
>
> Szmutku Zolt�n wrote:
> > Hi,
> >
> > Valid or invalid ... indifferent .
> > MySql can store '    .  .  '  or  '0000.00.00' values  to date field.
> > Formerly I  use Mysql , and now change to Postgres (single reason : the
> > faster, record level transactions in the Postgre ) .
> > My client classes (VFP 6) use empty date values and NULL values for
> > different signify.
> > If the Postgre not handling the empty date , then more complicated
rewrite
> > my older classes to Postgre for me.
>
> If you don't want to store dates, you could always use a text-field.
>
> Can I ask what the different meanings are for null vs "empty" date fields?
>
> --
>    Richard Huxton
>    Archonet Ltd
>
>
>