<div>
Crit,<br />
<br />
Maybe the date field was defined as &quot;NOT NULL&quot; in your database?<br />
<br />
In that case it cannot be empty.<br />

</div>


Crit,

Maybe the date field was defined as "NOT NULL" in your database?

In that case it cannot be empty.


<div>
caraf_g,<br />
I just checked the database, and that is not the case. I can, through, SQL Plus update the date to an empty string, just not through VB<br />

</div>


caraf_g,
I just checked the database, and that is not the case. I can, through, SQL Plus update the date to an empty string, just not through VB


<div>
Can you show me the line of code that's causing the problem?<br />

</div>


Can you show me the line of code that's causing the problem?


<div>
Have you tried to send a 00/00/00 value to the field being deleted?<br />

</div>


Have you tried to send a 00/00/00 value to the field being deleted?


<div>
What is the exact error message you are getting? &nbsp;Perhaps you are trying to fill the field with invalid data such as slashes from an input mask, but no date? <br />

</div>


What is the exact error message you are getting?  Perhaps you are trying to fill the field with invalid data such as slashes from an input mask, but no date?


<div>
thanx for your help...........I'll let my boss sweat the rest!<br />
Crit<br />

</div>


thanx for your help...........I'll let my boss sweat the rest!
Crit


<div>
<div class="content wysiwyg-content">
I am connecting to an oracle database thru VB. One of the fields I am working with is a date field. If the date field already has a date in it, and I delete the date, and then update the record, I get an error, rather than the date being 'erased'. Any suggestions as to why this is happening would be appreciated.~~~~Crit
</div>
</div>


I am connecting to an oracle database thru VB. One of the fields I am working with is a date field. If the date field already has a date in it, and I delete the date, and then update the record, I get an error, rather than the date being 'erased'. Any suggestions as to why this is happening would be appreciated.~~~~Crit

Record update problem

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.