Re: [DUG]: Query Parameters

[Aaron Scott-Boddendijk]

> However under ADO and MSSQL7 the following does work!
>
> select
>   case :FieldNo
>     when 0 then Column1
>     when 1 then Column2
> end
> from Table

is that similar to the oracle decode?

select decode(:FieldNo,0,Column1,1,Column2,null)
from table;

Assuming of course that ORACLE will bind a parameter to field in this
case...

Which I haven't tried...

--
Aaron Scott-Boddendijk
INTAZ Limited
+64 7 838 3371 Voice
+64 7 838 3372 Fax


---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"