error message help

tford · Post by **tford** » Fri Apr 27, 2007 2:28 pm

I am running a query and getting the following error message:
"Internal error. Error reading business object. Comparisons between SMALLINT and CHAR are not supported. "

Can you give me any clues where to start with problem solving?

Thanks,
Tom

aware_support2 · Post by **aware_support2** » Tue May 01, 2007 7:27 am

Hi Tom,

This indicates a numeric value is used in search for a text attribute or vice versa. To avoid the problem use search values of the same type as object attributes.

aware_support · Post by **aware_support** » Tue May 01, 2007 12:55 pm

Can you please also send your BSV file to [email protected] and tell us how to reproduce the problem.

tford · Post by **tford** » Wed May 02, 2007 6:18 pm

Sent. I look forward to your feedback.

Thanks!
Tom

aware_support · Post by **aware_support** » Thu May 03, 2007 6:47 am

Turned out that the attribute of the Yes/No type was used to compare with a string value: Object.YesNoAttr = 'null'

The original intent was to check for the undefined value which should be done like this: Object.YesNoAttr IS UNDEFINED