Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ms Access dataType DATETIME
Message
From
24/11/2001 13:33:03
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00585049
Message ID:
00585405
Views:
27
The error happens when you try to put into Access empty DateTime fields.
I found out that the problem doesn't occurs if you convert the empty field into a null value.
REPLACE TField WITH IIF(EMPTY(TField),NULL,TField)
THEN:
=TABLEUPDATE()
Previous
Reply
Map
View

Click here to load this message in the networking platform