Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not same result when going through OleDb
Message
De
16/04/2006 23:49:30
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Not same result when going through OleDb
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01113992
Message ID:
01113992
Vues:
52
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform