Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Null Date Error

Status
Not open for further replies.

vr

Programmer
Oct 14, 1999
54
US
I am trying to write an SQL statement to update dates on an Oracle table. When the date is null in the recordset, an error is received. Access VBA is not allowing Decode or To_Date to be utilized.

Can anyone provide an alternate solution?
 
Just a thought,

You could use isNull(<recordName>) in a VB module to catch the null dates and then change them to some default value that Oracle can accept. I have no experience with Oracle, not sure if this will work for your situation.

Matt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top