Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Syntax Result *************
Message
From
30/09/2006 22:30:27
Arjun Bagojikop
Dynamic Super Software
Sangli, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Syntax Result *************
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158421
Message ID:
01158421
Views:
61
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
Next
Reply
Map
View

Click here to load this message in the networking platform