| Subject | cast in select needs alias |
|---|---|
| Author | Dieter Tremel |
| Post date | 2001-11-09T09:55:45Z |
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.
Greetings Dieter Tremel
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.
Greetings Dieter Tremel