General information
Category:
Coding, syntax & commands
Alejandro
You should also be aware that if you have any blank date fields that they will be changed to 12/30/1899 or possibly 1/1/1900 in SQL Server, since ODBC has no concept of blank dates.
As far as changing code globally, you can use GOFISH app from downloads to search for occurrences of specific text and change it using its edit capabilities. Much faster and less error prone than manually searching and editing multiple files.
Or, as Sergey suggested, you can map your datetime fields to date data type in your remote views and your code needs no changes except to handle the blank dates being replaced with a default date.
HTH
Elmer
Previous
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