PMFJI, When you browse the view does the date field show NULL, Blank date or {01/01/1990}?
If it is showing the NULLS or an empty value, you may find that the date input mask is your problem. Just a SWAG, but try removing the input mask from the control that displays the date. The input mask may be changing the NULL to a blank date as you scroll through the view with a blank date being sent back to SQL Server. In ODBC for SQL Server, blank dates translate to 01/01/1990, In VFP database, they translate to 12/30/1899.
HTH
Previous
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