Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Coalescence blues
Message
From
14/03/2017 12:17:48
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
C# 5.0
OS:
Windows 8.1
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01649038
Message ID:
01649052
Views:
27
>>>In his code he doesn't need ?? operator, I believe.
>>
>>He does.
>
>You're right. For a minute I thought SUM will produce 0 when no results are matching, but I ran a test in SQL Server and got NULL, so that answers my original incorrect thought.

Got you, in VFP too (in 7.0?) it was also changed to return NULL and people complained at that time as I remember. Here the real problem is ?? with two non null values is an exception for C# (why in the world I don't know, that is MS after all).
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform