>Hello everybody,
>
>I'm using VFP8 SP1 and SQL 2000 in the back end, there is one field in
>one of the tables that keeps coming back "empty" when in the back end is
>NULL, this causes a conflict; error 1585; when the record is saved.
>I can't figure out what the problem is, any thoughts on that?
>
>I'm using remote views with ODBC
>
>THIS.Thankx("In Advanve")
Are you sure it is the empty date field that is causing the error? Normally, empty date values in VFP get stored into SQL Server as "01/01/1900". Unless your table has a trigger that blocks dates with that value, I'd be surprised that it would cause an error.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.