Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save empty date using ADODB.Connection
Message
From
04/06/2008 05:44:27
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/06/2008 15:22:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01321396
Message ID:
01321524
Views:
13
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform