IF Statement Question in Pervasive

[SQLDBA007]

Hello!

I am trying to fix this IF statement error. All i want is the value of column 'Column2' to display if column 'Column1' = y.

IF (Column1 = 'Y', Column2 , '0') "ColumnTEST",

The data type for column2 is numericsts and the data type for Column1 is char.

This is the error message i get:
ODBC Error: SQLSTATE = S1000, Native error code = 0
Incompatible types in expression.

What am i doing wrong here? the SQL statement seems fine, to me. Any thoughts and comments are highly appreciated. Thanks in Advance!

 

[mirtheil]

You'll probably need to Cast (or convert depending on the version of PSQL) the Column2. So something like:
IF (Column1='Y',Convert(Column2,SQL_CHAR), '0') "ColumnTEST",





Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[SQLDBA007]

Beautiful!!!! it worked!! u da man mirtheil!!