Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date 12/30/1899 when moving to remote view.
Message
From
04/03/2004 15:53:01
 
 
To
04/03/2004 15:35:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00883252
Message ID:
00883264
Views:
6
>My app was working just fine with local views, but when I began testing it with remote views, my blank dates came back as 12/30/1899. I think I recall reading somewhere this was a default for empty dates, but I need them to actually be empty {//}. Is there an easy way to do this? I'd prefer avoiding NULLS.
>
>Chris.

Most back ends have no concept of an empty date, that's what NULL is for. About all you can do is swap out the values (lots of work) or just handle it when needed for display purposes.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform