Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inlist() woes
Message
De
04/03/2002 15:06:46
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00627988
Message ID:
00628012
Vues:
14
Just figured that out! Thanks for everyones help!

>SET ANSI Command determines how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands. See help for details.
>
>>Hi all!
>>
>>My problem with inlist() is .... well here's an example
>>
>>Select * from dline where inlist(cde_tooth, '14', '1')
>>
>>I get any tooth code that starts with a 1. I did some searching here on UT and found the solution of SET EXACT ON. So, I tried that. Didn't work.
>>
>>The cde_tooth field is c(2). And if I modify my code to
>>
>>Select * from dline where inlist(cde_tooth, '14', '1 ')
>>
>>then I get the correct results, just 14's and 1's. That shouldn't be like that though, should it? Maybe I'm missing something....
>>
>>
>>thanks in advance!
"In three words I can sum up everything I've learned about life : it goes on." - R. Frost

Amanda Brown
Supervisor/Programmer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform