>>>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

Thanks, George. I guess I'll do a combination of both remote views and SQL pass-through. The Robert Green article was quite good. The CREATE SQL VIEW is very slow. I can't do that every time I want to run a select statement. I'll have to pre-configue some views, and use SPT for others.