[firebird-support] Re: RES: VIEW CREATES ON FB 2.5 BUT DO NOT CREATE ON FB 1.5

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

29.11.2016 13:45, 'Israel Pinheiro' wrote:
>
> Invalid Token. Dynamic SQL Error. Invalid Command Data Type unknown

Check datatypes of all union parts, i.e.

select A1, B1, C1
union
select A2, B2, C2
union
select A3, B3, C3

Data types for (A1, A2, A3) should match exactly. The same for B and C.


Dmitry