Building a complex query

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Building a complex query

Message

26/01/2005 11:13:52

Colin Northway
Colin Northway Associates
London, Royaume Uni

26/01/2005 11:04:45

Borislav Borissov
Microcomplex
Sofia, Bulgarie

Information générale

Forum:

Visual FoxPro

Catégorie:

Autre

Titre:

Re: Building a complex query

Versions des environnements

Visual FoxPro:

VFP 6

OS:

Windows 2000 SP4

Network:

Windows 2000 Pro

Database:

Visual FoxPro

Divers

Thread ID:

00980679

Message ID:

00980804

Vues:

>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

Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing

Répondre

Fil

Voir

Click here to load this message in the networking platform