General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
For ODBC, there is no concept of a blank date. I'm not sure why that is but blank dates in a VFP table will be stored as 12/30/1899 and in SQL server as 01/1/1900. The only way that I know to represent a blank date in a date or datetime field using ODBC, as Borislav indicated, is to set the field to allow nulls and set it to null.
>Hello everyone, How can I assign a blank record date to a field date datatype if im using a sqlremoteview and my based table is still the native DBF.
>
>Replace datefiled with {}
>
>This line wont work anymore i get an err msg of Data Type mismatch.
>
>I hope someone can help me on this.
>
>Thanks and regards,
>Marlon Estrelon
Previous
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