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
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