Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA, SQL Server Datetime issue with Buffering
Message
From
17/08/2006 01:16:53
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01146148
Message ID:
01146261
Views:
18
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform