>CREATE OR ALTER VIEW ESPELHO(
...
>Error Message is:
>Invalid Token. Dynamic SQL Error code = -104. Invalid Command. Data
Type unknown
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 TM
>INNER JOIN EQPRODUTO eq on mp.codprod = eq.codprod
Mixing SQL-89 and SQL-92 like you do above is not recommended (although
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
