Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

-support] <firebird-support@yahoogroups.com> escreveu: > > > Roda certo no 2.5. A View funciona corretamente na aplicação com o 2.5 > porém tenho dois clientes que estão com FB 1.5 e não consigo criar a View > > Em 23/06/2016 18:07, "Gabriel Frones grfro...@gmail.com &g

Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

Eu preciso de informações sobre suas tabelas (essas envolvidas) e que tipo de relatório essa view fornece pra te dar uma query que funcione. Mas uma dica geral a principio é: isole o problema. Primeiro construa uma query que funcione, depois tente criar uma view com ela. Essa query não roda?

Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

sorry, I'm wrong here... the cross join syntax is new in FB 2.0+, but the comma syntax is already there. Em qui, 23 de jun de 2016 às 17:55, Gabriel Frones escreveu: > Israel, > > the error is because cross joins (from a, b) are only supported with FB > 2.0+. See here:

Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

Israel, the error is because cross joins (from a, b) are only supported with FB 2.0+. See here: http://firebirdsql.org/refdocs/langrefupd20-select.html But your problem is greater than that: I'm pretty sure (from my knowledge of sql and by reading the field names - I'm brazilian too) your query

Re: [firebird-support] Users for application

You can still see which process is doing what using a single user, though, since the system tables provide you with process name (foo.exe) and ip address for each transaction. I have the feeling that users are only worth the management cost if you're in a big corporation with a bunch of

Re: [firebird-support] Schema pluses?

Firebird has no support for schemas, IIRC... or am I missing something? Em dom, 12 de jun de 2016 às 18:18, 'livius' liviusliv...@poczta.onet.pl [firebird-support] escreveu: > > > Hi, > > what are + and – with working with schema? > What benefits are between >

Re: [firebird-support] Stored Procedures Execution Plan

It was sent and received... but this is working for me out of the box in FB 2.5.4. I just write the select * from SP and ask for plan and it gives me the plan for the inside statements. Haven't tested on non-selectable SPs. Em qua, 25 de mai de 2016 às 08:20, João Paulo Carvalho