Building a complex query

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Building a complex query

Message

From

26/01/2005 11:13:52

Colin Northway
Colin Northway Associates
London, United Kingdom

26/01/2005 11:04:45

Borislav Borissov
Microcomplex
Sofia, Bulgaria

General information

Forum:

Visual FoxPro

Category:

Other

Title:

Re: Building a complex query

Environment versions

Visual FoxPro:

VFP 6

OS:

Windows 2000 SP4

Network:

Windows 2000 Pro

Database:

Visual FoxPro

Miscellaneous

Thread ID:

00980679

Message ID:

00980804

Views:

>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

Map

View

Click here to load this message in the networking platform