Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null date fields in an SQL Table
Message
From
21/08/2002 14:06:37
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:
Null date fields in an SQL Table
Miscellaneous
Thread ID:
00692118
Message ID:
00692118
Views:
58
My form uses an ODBC connection to connect to an SQL table base on a view. In this table is a date field which I set to accept null values. When I scroll through records on my foxpro form, that has this date field on it, with an input mask of a date field, the value in the SQl table end up being 01/01/1900. Any ideas on how to prevent this ?
Next
Reply
Map
View

Click here to load this message in the networking platform