Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing dates programmatically
Message
From
26/10/2005 06:59:52
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01062160
Message ID:
01062162
Views:
18
Can anybody tell me how I can remove a date form a field programmatically. Many Thanks

I am not sure what you mean by "remove". If you mean hat you want to blank it out, in VFP:
REPLACE MyDateField WITH {} IN MyAlias
If this is going to update SQL Server, you can't do this because empty dates are not supported. You have to do use .NULL. instead of {}
Previous
Reply
Map
View

Click here to load this message in the networking platform