>>What about a remote view. That'll allow you to map the date/time to a date field.
>
>George. Suppose I create a DBC with a remote view in it. Is there a way to dynamically change the WHERE clause (ie. the filter) of that view to a new expression and requery it? CURSORSETPROP and DBSETPROP don't let me change the SQL.
Sure, just re-create the view via DELETE VIEW < view name >, then CREATE SQL view. There's a bunch of code involved, however in doing this. Again, GENDBC can be of help here.
You also might want to look at the article "Integrating SQL Server with Visual FoxPro" by Robert Green. While I'm sure that much of it you'll probably already know, you might find his discussion of the pros and cons of views versus SPT useful. The article can be found at:
http://msdn.microsoft.com/library/techart/msdn_bko02.htm
George
Ubi caritas et amor, deus ibi est