Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
HAVING Clause invalid error
Message
From
13/06/2006 08:18:41
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
HAVING Clause invalid error
Miscellaneous
Thread ID:
01128635
Message ID:
01128635
Views:
70
Probably obvious to someone, just not me. Getting an error on the HAVING clause. If I run without the clause, I get a valid cursor with records and values in the Asset and Liability fields.
SELECT IIF(ISNULL(MsBench.CatName), PADR("Other",25," "), MsBench.CatName) as Category, ;
	SUM(crsAssetsLiab.Asset) as Asset, ;
	0.000 as AssetPct, ;
	SUM(crsAssetsLiab.Liability) as Liability, ;
	0.000 as LiabPct ;
	FROM crsAssetsLiab ;
	LEFT OUTER JOIN Mornstar ;
	 ON crsAssetsLiab.Acct_Id = Mornstar.Acct_Id ;
	LEFT OUTER JOIN MsBench ;
	 ON MornStar.CatId = MsBench.CatId ;
	GROUP BY 1 ;
	INTO CURSOR crsBalByCat READWRITE ;
	HAVING Asset <> 0 OR Liability <> 0
Next
Reply
Map
View

Click here to load this message in the networking platform