SQL*ASSIST QUESTION ??

From: DEREK KONRAD <KONRAD_at_BMS.COM>
Date: Tue, 28 Jun 1994 14:34:19 -0500
Message-ID: <KONRAD-280694143419_at_bullwinkle.bms.com>


This is question regarding SQL*Assist.

Could someone tell me as to why I was unable to use the 'Decode' function in SQL*Assist. I was able to run the SQL (select st.) statement perfectly in
SQL*PLUS. But when I ran the same statement in SQL*ASSIST, it gave me an error

'missing parameter' followed by
the entire decode statement.

the decode statement was in the if then else format viz.
decode(table1.comparison,'>=','>='||view1.min,'<=','<='||view1.max,null)

thanks in anticipation Received on Tue Jun 28 1994 - 21:34:19 CEST

Original text of this message