When I try to insert/update a null value in a field datetime with an SQL
command, it´s generate an exception using .net oledb.

I had try this SQL command:

UPDATE MYTABLE SET MYDATETIMEFIELD = '' WHERE MYCODE = 1.

Ps: The column allow null values, I tested it in msaccess 2000 XP
environment.

thnx

Diovani

Hello Diovani

You are attempting to set the date to an empty string, not a null. Try
this:

UPDATE MYTABLE SET MYDATETIMEFIELD = NULL WHERE MYCODE = 1.


"Diovani" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I try to insert/update a null value in a field datetime with an SQL
> command, it´s generate an exception using .net oledb.
>
> I had try this SQL command:
>
> UPDATE MYTABLE SET MYDATETIMEFIELD = '' WHERE MYCODE = 1.
>
> Ps: The column allow null values, I tested it in msaccess 2000 XP
> environment.
>
> thnx
>
> Diovani
>
>