>We are migrating an app from VFP 6 to VFP 9 and running into a behavior I don't understand. This one particular program blows up doing a comparison between a DateTime field in a SQL Server database and a memvar of type Date. It worked fine in VFP 6. I have poked around in the help looking at What's New, various topics about data types, and about SQL Server. Does anyone know? What I am really hoping to find is a VFP setting I can set application wide that will take care of this. Having to find and fix all problems like this in the app would be time consuming. (Finding all commands where a DateTime field is compared to a Date memvar -- how the heck do you do THAT other than checking every usage of every DateTime field? Yuck).

Mike,

I don't get the error in VFP9 in the simple test below or with a remote view. What could be different on your side?

CREATE CURSOR Test (dt t NULL)
INSERT INTO Test VALUES(DATE())
lcDate = DATE()
? dt = lcDate