Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Building a complex query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
00980679
Message ID:
00980808
Vues:
102
>>Try:
>>
>>IF .NOT. EMPTY(consig) && If this variable contains Company name
>>   consig = ALLTRIM(consig)
>>   cWhere = cWhere = cWhere + IIF(lAnd," AND ","")  + "globalnew.Company LIKE '%"+consig+"%'" && Add ' before first & after second %
>>   lAnd   = .t.
>>ENDIF
>>
>
>Borislav
>
>No that produces the same answer
>
>
>Colin


There is a many cWhere = cWhere = ;O)))))
IF .NOT. EMPTY(consig) && If this variable contains Company name
   consig = ALLTRIM(consig)
   cWhere = cWhere + IIF(lAnd," AND ","")  + "globalnew.Company LIKE '%"+consig+"%'" && Add ' before first & after second %
   lAnd   = .t.
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform