Not able to add filter in FM

[Gnani]

Hi,
when i am adding a filter in Query subject in FM, run button is disable. If I test it, then getting below errror.
.........................................
This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0144 An arithmetic exception was detected.
[Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression.
........................................................

Without filter i'm able to test it successfully.....
Ur help would be appreciated.


...Gnani...

[MFGF]

Hi,

It sounds like the syntax of the filter you are adding is not appropriate.  My guess is that you are trying to treat a character item as numeric (or vice versa).

How have you coded the filter, and what data type(s) is (are) the underlying item(s) used in the expression?

MF.

[Gnani]

MF,
Thank you.......