Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Recommended way to handle empty dates when upsizing
Message
De
07/09/2007 13:05:00
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01253043
Message ID:
01253061
Vues:
20
Wow. I did some tests with IF statement, BETWEEN() and SET FILTER TO and was surprised to find that even though the result of comparisons is .NULL. it is treated as NOT .T., so for all practical purposes it behaves as .F. which is appropriate. I expected VFP to give an error in the tests above, and don't know where I got that idea. Did VFP use to give error in previous versions?

This data will be used with VB.NET. Do you know if VB.NET behaves is a similar, reasonable, manner?

Thank you for the help,

Alex



>Hi Alex,
>
>It's a kludge and I don't like kludges when there's other way. I'm not sure why would you check for null everywhere?
>
>>Thank you, Sergey. That seems the most "correct" way, since it is an unknown value, but what about having to check for null everywhere? Would using 01/01/1900 (or any other date) make any sense to you?
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform