Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC and empty date
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01280300
Message ID:
01280310
Vues:
31
><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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform