>hi
>friends
>i am vfp programmer using sql 2000. i have created cursoradapter in my dataenvironment using cursor in from. my user fill blank date
>after cursor updated store datetime in sql '01/01/1900 12:00:00 am'.
>user want to store blank datetime i have try to save null value. when user adding new record default null but user go on datetime text box mistakly type date. he want no need date here,he arase date and saveing record but datetime have been stored in sql
>'01/01/1900 12:00:00 am'.
>
>Plese Suggest me how can i stored blank date in sql 20

What I use is to allow DateTime fields in SQL Server to allow NULL and all blank dates from VFP goes as NULL in VFP. Of course when you need function to convert you empty date fields to NULL when you send them back. Becuase I use CAs to manage remote data I have a method in my base class which do that and just use ConversionFunc property of CA for all date fields.