Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Abnormal behavior of INLIST command
Message
De
27/06/2005 11:53:31
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Abnormal behavior of INLIST command
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01026745
Message ID:
01026745
Vues:
70
mylist1='"a1","a2 ",...,"a12"'
mylist2='"b1","b2 ",...,"b14"'

It works: select * from mytable WHERE INLIST(field1,&mylist1 ) '
It works: select * from mytable WHERE INLIST(field2,&mylist2 ) '
It does not work:
select * from mytable WHERE (INLIST(field1,&mylist1 ) or INLIST(field2,&mylist2 ))

However it works when the arquments in mylist1 and mylist2 are less than 6.
It is supposed that the arquments in the INLIST command can be up to 24

Thanks,
Yiorgos
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform