>>Does anyone have a suggestion on how to handle date (as opposed to date-time) fields on SQL-server, using SQL-pass-through?
>
>What about a remote view. That'll allow you to map the date/time to a date field.
Well George, I tried that and it seems to work. So maybe it's the solution I need. Although I thought that George Simon's idea was interesting too.
So here's my next question: (I'm really a pest, eh?) If FOXPRO can do that with views, why can't I do that with SQL pass-thru? What is FoxPro doing?
In a different message you told me that you once traced the ODBC calls FoxPro made to learn how FoxPro did some things automatically. How do you do that? I started ODBC logging, but couldn't make head nor tail of what was in \SQL.LOG. There's also the Visual Studio Analyser, but I don't know where it writes its stuff nor how to get it out.
BTW, I used your LNKFILES.DLL. It worked great. Thanks!
Tom Green in Montreal