Sergey,

>Why do you think that error is generated for the datetime field not some other field?

I'm totally clueless!

>How do you send updates, RV, SPT?

RV

>You can use SQL Server profiler to see what was sent from VFP to SQ Server.

There are a myriad of options in the SQL Server profiler, what should I
be looking at?

TIA

>
>>Textbox valid:
>>
>>

>>If Not Isnull(This.Value) And This.Value <= Date()
>>   If Empty(Dtos(This.Value))
>>	Update CarsMemo SET Initials = Thisform.cUser
>>	This.Value = NULL
>>	DoDefault()
>>   Else
>>	Return 0
>>   Endif
>>Else
>>   Update CarsMemo SET Initials = Thisform.cUser
>>   DoDefault()
>>Endif
>>

>>
>>When saving I get the String data, right truncation error from the server.
>>
>>So, why can't I set a datefield to null?
>>
>>TIA