Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null date fields in an SQL Table
Message
 
To
21/08/2002 10:48:19
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00691903
Message ID:
00692117
Views:
29
>it definetly is not being stored as a NULL value. IF I reset it to NULL afterward it shows as BLANK on the screen, but when the value is BLANK (not null) it gets saved as 01/01/1900

Use validation on the control to change the empty date to a null, then it will store a null date to SQL. SQL has no concept of what an empty date is.
* If the user removed the date, store a .NULL.

IF EMPTY(This.Value)
	This.Value = .NULL.
ENDIF

RETURN DODEFAULT()
Previous
Reply
Map
View

Click here to load this message in the networking platform