General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Date field in an ODBC connection to SQL server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only