Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date fields on SQL-Server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00459116
Message ID:
00459166
Views:
34
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform