How to replace limit amount with zero

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to replace limit amount with zero

Message

13/06/2006 21:24:49

Paul Pravong
Québec, Canada

13/06/2006 20:56:09

Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: How to replace limit amount with zero

Divers

Thread ID:

01128871

Message ID:

01128881

Vues:

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

Répondre

Fil

Voir

Click here to load this message in the networking platform