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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Item "" does not pass validation test?

Status
Not open for further replies.

kaul125

Programmer
Jan 29, 2002
87
US
I have PB6.5 app. running on SQL Server 7 and SQL Server 2000. I have a datawindow that consists of checkboxes. The database field tied to the checkboxes is a smallint. The data value passed to the database from the datawindow edit properties is 1 for 'On' and 0 for 'Off'.

Everything is working fine when I check the checkboxes on and off in SQL Server 7. However, when this application is running against SQL Server 2000 and I click to check any of the checkboxes on this particular datawindow, I get the following error from the itemerror event:

Item "" does not pass validation test?

I'm unable at this point to debug the application on the SQL Server 2000 database, because I don't have that environment setup. I did verify with the home office, of my company, that the database fields for this datawindow is of type smallint.

Why would I get this error when I feel the app. is passing the right datatype to the database? The error mentioned above states that an empty string is trying to be passed. How can this happen when I know the datawindow was compiled with the proper edit properties?

What else can be causing this error? I exported the dwo and verified the data values for the columns.

Keith
 
thid happens when the DB does not allow empty strings (as nulls)..two ways to fix it either on DB side or PB side

I like the PB approach

DB side:
in DB allow the column to accept empty string as valid value

PB side:
in dw column property check the Empty string is null property
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top