Leemi
Thu Jan 29 10:46:39 CST 2004
Hi Andrew:
Yes, you can issue a SET DATE command via the ODBC driver. See this
article for an example:
259192 PRB: Updating a Table with DTOC() in an Index Using ODBC
http://support.microsoft.com/?id=259192
As far as a resource, look for a VFPODBC.TXT file on your machine. The file
will probably be in the Windows\System32 folder. There is also a Drvvfp.hlp
in the same folder.
We removed some VFP commands and functions from the ODBC driver for
security purposes. Here is a list for you to look at:
246660 PRB: Certain Commands & Functions Removed from Visual FoxPro ODBC
Driver
http://support.microsoft.com/?id=246660
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003
>Hello,
> another ODBC question; can I change the date format for queries via
>ODBC?
>In fox itself I'd use DATE=BRITISH in the config.fpw or SET DATE BRITISH in
>code. Can I do anything similar via ODBC?
>In fact, is there a good resource/document on using ODBC with fox? I'm
using
>the VFP ODBC driver that came with MDAC 2.6 on FPW2.6 tables.
>--
>TIA