Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Confusion over NULL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01203230
Message ID:
01227050
Views:
32
>I am using a REMOTE VIEW through an ODBC connection.

Unfortunately I have no big experience with remote views.
You map a DateTime field to Date one in the view, right?
I thing that it is a VFP job to conver it back to datetime when you send back to ACCESS.
Not sure about EMPTY DateTime fields in ACCESS also, but maybe in ACCESS that field is not NULLable and when you send back a NULL in that field you got errors. What happens if you put: DATE(1900,1,1) in your RV instead of empty date or NULL?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform