Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null - Blank DateTime value
Message
From
08/06/2006 07:59:06
 
 
To
08/06/2006 07:13:24
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01127723
Message ID:
01127797
Views:
11
>In most applications you don't care the difference between a null or "" or null and 0.

Well, I do, if it is necessary. The difference to an empty date or datetime field is, that "" or 0 re regular values for their particular types, but {//} isn't. You cant do anything with an empty date value. A zero is a regular value for a numeric field. The zero tells me some value, but what does a {//} tell me?
If the zero is not valid for the special case, I would recommend using the NULL as well.

And in this special case another problem comes into the game. If you query a VFP table with date fields via ODBC, all empty date fields will show December 30th 1899 as their value. How can you distinguish between empty date fields and fields that really contain this value?
Holger Vorberg
Germany
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform