Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EXACT setting in VFPOLEDB
Message
From
02/03/2004 17:42:15
Nancy Folsom
Pixel Dust Industries
Washington, United States
 
 
To
02/03/2004 12:05:29
Kevin Lawrence
Cornwall Council
United Kingdom
General information
Forum:
ASP.NET
Category:
Other
Title:
Re: EXACT setting in VFPOLEDB
Miscellaneous
Thread ID:
00882377
Message ID:
00882528
Views:
28
This message has been marked as the solution to the initial question of the thread.
>Hi
>
>I'm trying to execute a SELECT statement using the VFPOLEDB provider from .Net, but unfortunately it acts as if EXACT is set to on, I've tried issuing a Command of "SET EXACT OFF" after opening the connection, but the SELECT always obtains the exact matches.

SELECT uses SET ANSI, not SET EXACT. However, the default for SET ANSI is OFF.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform