Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL select brings record over even when not match
Message
De
15/09/2005 11:41:01
 
 
À
15/09/2005 11:23:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01049862
Message ID:
01049937
Vues:
17
Found it. The .NULL. in that field were causing the problem. Converted them to "" and It works now.

Thanks for the Help.
>So, first you had too many records, now too little of them. Well, that indicates that there is one more problem with your code. Can you do the query without the WHERE line? Does it give the records that you want in your result?
>
>>Putting that statement in the where line, gets me no results found. There should be 5 records coming back.
>>
>>Thanks anyway.
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform