[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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