>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only