Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exact OFF Strrange Behaviour
Message
De
23/12/2003 03:42:15
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00861443
Message ID:
00861520
Vues:
21
Hi Hani

If the select statement you have written is correct, you are actually asking for ALL records! PLease drink a cup of coffee, and reread it.

*I am using SQL Statement which brings more records than I need because it behaves like SET EXACT OFF, here is my statement
*SELECT code from items where alltrim(code) >= '140' and alltrim(code) <= '140'
*The Result sets contains records for item = '140' and item = '1404'
*I even tried to set exact on but with no change.
*Any Help on that
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform