Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not same result when going through OleDb
Message
From
16/04/2006 23:49:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Not same result when going through OleDb
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01113992
Message ID:
01113992
Views:
51
From .NET, if I use OleDb to access VFP data, I will not get the same result. From VFP, the following SQL find the related records, thus returning all records having DBUsers.Name starting with D:
SELECT DBUsers.AI AS FTNumero FROM DBUsers WHERE UPPER(DBUsers.Name)=UPPER("D")
But, through OleDb, this returns 0 record. If I don't put any condition, I can see that all records area being returned. So, the problem is related to the way the condition is made. Can anyone explain this difference with OleDb?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform