set dataset item 'date' to null

  • Thread starter Thread starter El Camino
  • Start date Start date
E

El Camino

Howdy all

Picture this:

dtsdate.Tables("Batch").Columns.Add("Date", typDate)
dtsdate.Tables("Batch").Rows(0).Item("Date") = dbnull

Im trying to set the item to a dbNull value....

But i always get and error when the query execute.

Thanx
 
El Camino said:
Howdy all

Picture this:

dtsdate.Tables("Batch").Columns.Add("Date", typDate)
dtsdate.Tables("Batch").Rows(0).Item("Date") = dbnull

Im trying to set the item to a dbNull value....

But i always get and error when the query execute.

Thanx
Click to expand...


dtsdate.Tables("Batch").Rows(0).Item("Date") = DBNull.Value
 
Hi El Camino

I think it should be
dtsdate.Tables("Batch").Columns.Add("Date", typDate)
dtsdate.Tables("Batch").Rows(0).Item("Date") = dbnull
Click to expand...
dtsdate.Tables("Batch").Rows(0).Item("Date") = dbnull.value

I use it like that and no problems

I hope this helps?

Cor
 
Back
Top