Subject | Re: RES: [firebird-support] It works on FB 2.5 but does not work in FB 1.5 |
---|---|
Author | setysvar |
Post date | 2016-06-23T20:45:04Z |
>CREATE OR ALTER VIEW ESPELHO(...
>Error Message is:Type unknown
>Invalid Token. Dynamic SQL Error code = -104. Invalid Command. Data
CREATE OR ALTER VIEW was new in Firebird 2.5. I don't even think ALTER
VIEW existed in Firebird 1.5, but CREATE VIEW should exist.
>FROM EQMOVPROD MP, EQTIPOMOV TMMixing SQL-89 and SQL-92 like you do above is not recommended (although
>INNER JOIN EQPRODUTO eq on mp.codprod = eq.codprod
it is legal) in any version. Rather, change this to SQL-92 only, e.g.
like this:
FROM EQMOVPROD MP
INNER JOIN EQTIPOMOV TM on MP.CODEMPTM=TM.CODEMP
and MP.CODFILIALTM=TM.CODFILIAL
and MP.CODTIPOMOV=TM.CODTIPOMOV
INNER JOIN EQPRODUTO eq on mp.codprod = eq.codprod
HTH,
Set