Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date field in an ODBC connection to SQL server
Message
From
20/08/2002 12:19:47
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Date field in an ODBC connection to SQL server
Miscellaneous
Thread ID:
00691520
Message ID:
00691520
Views:
62
I have a date field that is in an SQL table which I am accessing via an ODBC connection to the SQL Table. I have the field set to accept null values. When I scroll through records on my form where I have the input mask set as a date field, and the value is null, the value returns to the SQL table as 01/01/1900. If I don't scroll through the record on the form then the field stays as null. Is there any way that I can prevent this ?

Thanks For Your Help !

Stephen J. Hunt
Next
Reply
Map
View

Click here to load this message in the networking platform