At 10:55 AM 09-11-01 +0100, you wrote:

>Hello,
>
>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 ...'
>helps.

... 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 }}}}}}}

regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________