First, my server version, before I forget it: WI-V2.5.4.26856
I've been experimenting with nullable columns in composite pk's, and I seem
to have discovered some inconsistencies in Firebird's behaviour.
First, if we create a table like this:
create table A (
field1 char(10) not null,
fi
-support] 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
> [firebird-support]" esc
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? http:
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: http://firebirdsql.org/ref
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 i
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 developers
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
> schema_name__table_name and real sc
2.5.3 -> 2.5.5 is the same ODS, so you could just copy the file. But why
not do a backup/restore cycle?
Em qui, 2 de jun de 2016 às 10:50, 'Edward Mendez' emendez...@nc.rr.com
[firebird-support] escreveu:
>
>
> Hello all,
>
>
>
> I have 2 database servers running on Linux. One is running FB 2.5.
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
joao_paul...@yah