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:
00980814
Vues:
103
>>>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 %

Borislav

That's it

Thanks once again

Colin
>   lAnd   = .t.
>ENDIF
>
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform