Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Save empty date using ADODB.Connection
Message
De
04/06/2008 05:44:27
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
03/06/2008 15:22:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01321396
Message ID:
01321524
Vues:
14
>Hi,
>
>Using ADODB.Connection adding a parameter type 133, when I try to save (in DBF) an empty date ( like {} ) I get error.
>
>How can I to save empty date using ADODB.Connection ?

You can't. Set the value to NULL and accept NULLS on date and datetime fields (if you don't and try to preserve VFP's ability to use empty dates then sooner or later you'd be sorry - been there done that).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform