>>>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,
this is my second post on this, If you just issue oRecordset.AddNew(), all fields are empty by default, however I just tried this and received the error Microsoft Visual Foxpro ODBC syntax error when I issued oRecordset.updatebatch although oRecordset.update seems to work, at least it doesn't give an error

Regards

Pete