Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field does not accept null values
Message
 
To
08/12/1999 13:58:43
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Field does not accept null values
Miscellaneous
Thread ID:
00300521
Message ID:
00300558
Views:
16
Michael,

Try this;

SELECT NVL(SUM(a.totcxlcnt),0)-NVL(SUM(b.totcxlcnt) AS tsaleadj ...
Janis

www.JamesBooth.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform