>>>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
Jan,
you first stated you wanted to fill it with "01/01/1900", then you said an empty one, which one is it?, and when you say you receive an error, what error?
Regards
Pete Kane
Regards,
Peter J. Kane
Pete