Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
This seems to happen due to the fact that ODBC and SQL Server has no concept of a blank date. Have you tried to replace blank dates in your view with NULL just prior to saving the record and then do a table update? Does it still change to 1/1/1900? If so, I can see no way to resolve this if you cannot keep nulls in your date fields when updating from your remote view.
I had this problem with an application that used remote views with different database backends. Blank dates in SQL Sever changed to 01/01/1900 and FOX databases changed to 12/30/1899 which made it almost impossible to resolve. I tried for about a week while in the design stage but never did resolve it. In that application, I changed all date fields to character fields storing dates a YYYYMMDD and created formatting functions that converted it to the set date format when displaying and reporting. This allowed me to sort in date order and compare dates and date ranges effectively, but was not a pretty workaround.
Good luck! :)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement