>I have a remote view of a MS SQL Server table. When I upsized the original table VFP changed null values in a date field to 01/01/1900. I have since modified the SQL table to have NULL as the default value for this field.
>
>I am now trying to remove the 01/01/1900 values. However, I'm not having any luck. When I delete the values and requery the view, 01/01/1900 reappears.
>
>This does not happen with MS Query.
>
>Help!
>
>Jeff
I believe you answered your own question when you wrote:
" I have since modified the SQL table to have NULL as the default value for this field."
Initially, you didn't permit SQL Server to have a NULL date field so the ODBC driver filled 1/1/1900 in for you. If NULL would have been
initially permited ... I believe SQL Server would have let it stay NULL.
Gene
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