Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling null date save/display
Message
From
04/04/2007 12:02:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Handling null date save/display
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01212056
Message ID:
01212056
Views:
57
Hello all,

I'm sure this has been beaten to death, but I have not found a solution posted...

I'm trying to write a custom textbox control that is to be bound to a date field that allows NULL. As we all know, VFP will store empty date if you clear out the field. What I want to happen is to store NULL back if the field is empty. I have tried creating a value_assign method, but that seems to keep me into an infinite dirty buffer.

I know this can be handled in code to replace empty dates with null just before a tableupdate, but I would ideally like to have the textbox control handle this for me.
Next
Reply
Map
View

Click here to load this message in the networking platform