• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

VB no Char

I am using a True DB Grid to display the resultset. The grid is bound to a RDC. One of the columns which is numeric(5,2) if it were to have its contents cleared, at the time of saving gives the error message 'VB no Char.' I am connected to Oracle. Please let me know how to get around this.
0
Vinod1959
Asked:
Vinod1959
1 Solution
 
blwatkinsCommented:
The problem is that the field you are connected to will not allow you to enter a null value such as "" or no value in that collumn.  There are several ways around this, you can change the field, which may be a problem if you are attached to Oracle and cannot change that field's structure.  Second you could build a validate routine to ensure that the field will not be blank before you try to save it, by making it a zero "0".
0
 
Vinod1959Author Commented:
Thank you. That's what I had been thinking too.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now