How to replace limit amount with zero

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to replace limit amount with zero

Message

From

13/06/2006 21:24:49

Paul Pravong
Quebec, Canada

13/06/2006 20:56:09

Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: How to replace limit amount with zero

Miscellaneous

Thread ID:

01128871

Message ID:

01128881

Views:

I try this but not work so far,

select group,iif(OPTION='YES' and count(*) as mycount > 1 , LimitAmounT, 0000) as LimitAmount,;
    Option  group by group;
  from table1 into CURSOR TEMP 
BROWSE

PLease assist me, TIA

Map

View

Click here to load this message in the networking platform