Clearing the contents of a Datetime field :: ASPN Mail Archive

Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming

MyASPN >> Mail Archive >> perl-win32-database

perl-win32-database

Clearing the contents of a Datetime field
by Paul Davison other posts by this author
Mar 24 2008 9:14AM messages near this date

RE: update query fails as table gets locked by select query (sql blocking issue) | RE: Clearing the contents of a Datetime field

I am using ODBC to work on data in an Access database and need to find a way to clear a date
/time field. I have tried writing "0000-00-00 00:00:00" and "" into it and I get back Error:
 [-3030] [1] [0] "[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria e
xpression." 

Is there a method to clear the contents of a Date/time field or set it to a null value?

Paul

Thread:

Paul Davison

Shaun Wallace

Paul Davison

Steve Howard