Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Syntax Result *************
Message
De
30/09/2006 22:30:27
Arjun Bagojikop
Dynamic Super Software
Sangli, Inde
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Syntax Result *************
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01158421
Message ID:
01158421
Vues:
62
when i did use this sql syntax
Select Sum(IIF(!ISNULL(bal),bal,0)) As bal,accode,acname,"Opening Balance" As remname, wsdt As dt From PRINTopledger;
GROUP By accode,acname HAVING Sum(IIF(!ISNULL(bal),bal,0))<>0

Result: Sql query generated, but some of record in bal field appeared ********
i think and changed sql syntax

Select Sum(IIF(!ISNULL(bal),bal,0000000000.00)) As bal,accode,acname,"Opening Balance" As remname, wsdt As dt From PRINTopledger;
GROUP By accode,acname HAVING Sum(IIF(!ISNULL(bal),bal,0))<>0

Resuilt : Its Ok

But it is also limited thinking can u help me about Permanent solution
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform