Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view adding data to empty date fields
Message
From
06/07/2001 16:02:09
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00527561
Message ID:
00527630
Views:
14
>Are you using SQL Server?
No this is a fox back end through Microsoft ODBC Driver Ver. 6.01.8629.01

i am thinking this has to do with some ODBC concept of .null. for date fields. I am going to double check all the field settings even though I didn't conciously change them
>
>I am surprised you are getting the day before 1/1/1900, Are you substracting a day from your fields? No, These are dates that are filled in as certain events occur.

>
>>I have a remote view on a single table with several date fields. The view was created in the view designer.
>>When I browse this view from the project manager the empty date fields show up with 12/31/1899 in them.
>>
>>set century is on
>>set strictdate is 1
>>
>>if the view is set up as a local view, it displays normally.
>>
>>I have obviously done something silly, but I am at a loss as to where to begin.
>>
>>Thank you in advance.
>>
>>Brenda Erikson
Previous
Reply
Map
View

Click here to load this message in the networking platform