Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'Case' question
Message
De
02/04/2007 17:03:05
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
'Case' question
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01211479
Message ID:
01211479
Vues:
61
Hi friends. I have the following group of command in SQL:

SELECT table1.loanumber, 'CUOTA' =
CASE
WHEN sum(table1.amount) is null then 0
ELSE table1.amount
END
FROM table1
where table1.amount > 0
having CUOTA >0
GO


But, it send an error message : Invalid colun name 'CUOTA'
Really I have more command lines in this group but this is the central idea.
What can I do?...
Thanks in advance.

Carlos Burgos
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform