>>When I add a record (from VFP app) to SQL Server database table, field of type SmallDateTime gets value "1/1/1900". Is this by design? The field is set to allow NULLs so I thought that if I leave the date blank, it will set the value to NULL.
>
>You've to ommit that field from insert or pass null.
I realize that. But my question still stands, is it SQL Server that sets the field to 1/1/1900? (I wanted to be sure that it is not somewhere in the myriad of my VFP code that this value is set).
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham