>>I am using ADO to connect to FoxPro databases / table
>>
>>I am using date fields.
>>
>>When I append a record, with a date field in it.
>>I need to fill it with "01/01/1900" otherwise I recieve an error.
>>
>>The tables are also used by a old Dos FoxPro Program.
>>This program triggers records with date value " / / "
>>
>>Now i have i problem
>>
>>Can someone help me.
>>
>>Kind Regards
>>
>>Jan Dorresteijn
>
>Jan,
>if the recordset is read-write you can use oRecordSet.fields('yourfield').value = {01/01/1900}, then call the Update method
>
>HTH
>
>Pete Kane

Ok I understand. But I want to return an empty date not a filled one

How can i establish that.


Kind regards

Jan Dorresteijn