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