Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC and empty date
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01280300
Message ID:
01280310
Views:
21
><snip>
>>>? laError[2] ----> "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Data type mismatch"
>
>>There is NO such thing like EMPTY DateTime field in SQL Server.
>>That is why the only Fields I allow NULLs in them are datetime one.
>>If you insert an "EMPTY" datetime when you get data back you will see that you will get a perfectly valid date 01.01.1900.
>>SQL Server keeps DateTime as numeric valud that shows you how many seconds you should add to 01.01.1900 to get the value of the field.
>
>It would be impossible to access SQL Server with VFP ODBC driver, don't you think?


ROFL!!!!
I didn't saw the error message. I was so stuck with EMPTY dates and SQL Server :-)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform