Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CA, SQL Server Datetime issue with Buffering
Message
De
17/08/2006 01:16:53
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01146148
Message ID:
01146261
Vues:
17
SQL server does not permit empty datetime fields values, only nulls
Blank date is substituted at the bigining of the sentury
Set allow null
It will be null instead of empty
Use in VFP set nulldisplay for example to hide nulls on isnull(,) ms sql function ( equivalent of VFP nvl) to make query for remote datata
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform