Subject | Re: Re: FB & VFP6 How to store empty date |
---|---|
Author | Namit Nathwani |
Post date | 2004-09-09T04:13:18Z |
Hi Martijn
At 03:23 pm 08/09/2004, you wrote:
I tried {01/01/1899} and it said something that it cant read a property of
the table
I removed the default value complete and now I can add records, though they
look empty, but when I reopen the view I get .NULL. (the VFP equiv.) in the
date fields.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06/09/2004
[Non-text portions of this message have been removed]
At 03:23 pm 08/09/2004, you wrote:
>In this case, the birth-date is "unknown", in other words: NULL.Okay NULL here I come.
>An empty string ( '' ) does exist, but an empty date doesn't, unlessI tried putting a zero in the remote view but it said data type mismatch
>you choose the/a zero-date, eg: 1/1/1899 or so.
I tried {01/01/1899} and it said something that it cant read a property of
the table
I removed the default value complete and now I can add records, though they
look empty, but when I reopen the view I get .NULL. (the VFP equiv.) in the
date fields.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
namitbn@...
___________________________________________
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06/09/2004
[Non-text portions of this message have been removed]