Framework Manager convert error

[kclark]

Does anyone no what this error is:

This query contains an error and can not be executed.
It is recommended that you view the query feedback on the "Query Information" tab.

An error occurred while performing operation 'sqlOpenResult' status ='-28'.  and so on.

[cognostechie]

It could be for a no. of reasons but mostly this error comes up when you have a syntax error somewhere.

[kclark]

yes, it's saying error converting data type varchar to numeric.

The said query item is cast from varchar to numeric in another query subject.  Then a query subject references the casted query item and it's having trouble converting...why, it's already converted...

[cognostechie]

Check the data in the database..

[kclark]

That's what I mean the data in the database varchar...
Here's the scenario:

1. A query item is added to a query subject from the database.  This item is varchar
2. Another query item is added to the same query subject.  This query item is the same field that was brought in the previous step BUT it is casted to an integer datatype.
3. Now when I reference the casted field in a different Query Subject it throws me this error.  Is this not allowed in Framework Manager?

[Lynn]

Do you have any values in the varchar column that can't be converted to a number? Spaces, letters, etc. would be problematic. It is easy enough to query the database directly to see if this is the issue or not.

If it is a data problem, you might consider adding a check to ensure the varchar field is numeric and casting to number when it is or setting to 0 or null if it isn't.

[kclark]

Hmmm...I will try that and let you know...thanks!