Subject Re: [IBO] cast in select needs alias
Author Helen Borrie
At 10:55 AM 09-11-01 +0100, you wrote:
>a select like 'select cast('234' as integer) from ...' in IB_SQL results in
>an error 'Fieldname: not found'.
>In IBConsole it doesn't.
>Giving an alias like 'select cast('234' as integer) dummynumber from ...'

... one more good reason not to use IBConsole, methinks...

Here's another one for you: in Borland's Interbase 6 you can actually return an output column with no name. (This has been fixed in Firebird). IBO won't allow columns with no names. If IBConsole does, then maybe IBX does too. {{{{{{{ shudder }}}}}}}


All for Open and Open for All
InterBase Developer Initiative ยท