does not work. error remains...
De: [email protected] [mailto:[email protected]] Enviada em: quinta-feira, 23 de junho de 2016 17:45 Para: [email protected] Assunto: Re: RES: [firebird-support] It works on FB 2.5 but does not work in FB 1.5 >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 --- Este email foi escaneado pelo Avast antivírus. https://www.avast.com/antivirus
