>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement