Subject Re: FB & VFP6 How to store empty date
Author Namit Nathwani
Hi Dorin

Thanks for responding.

At 11:43 pm 07/09/2004, you wrote:
>You can either:
>1. Set a default value for column in VFP remote view

I have set it to {}, but if this is not attainable then I will have to put
it to something odd like 01/01/1245, and how odd will it look when the user
sees 01/01/1245 in a place where he does not want to enter any value like:

Please enter you birth date (optional)? People may not want to reveal the
date and would like to keep it empty. Now filling this to a date however
obscure like 01/01/1245 will have problem when you would like to know about
filled birth dates.

>2. Set a default value for column in database

Is empty date allowed in the database? Then I will go that route. Okay,
okay I know the answer <g>.

>I recommend you to have default values specified in RV for all columns

I have the RV auto populated with default empty values depending the data
type, in fact when the view was created the default value DBSETPROP() was
done with empty values so that there are no surprises with NULLs.

> with NOT NULL constraints in database.

I have tried NOT NULL in the database, it happens that the form looks like
and empty thing when it actually contains NULLs and if the user just tabs
through the form and saves the record all hell breaks loose because the
table does not want NULLs.

Softwares for Indian Businesses at:


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.754 / Virus Database: 504 - Release Date: 06/09/2004

[Non-text portions of this message have been removed]