Re: [firebird-support] Foreign key different field type

On Mon, Jun 19, 2017 at 1:21 PM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > , > > > > Can someone show me example when it is usefull to have different field > > type in [referenced and referencing keys of a foreign key relationship]? >

Re: [firebird-support] Why backlash do not raise parser error

20.06.2017 12:42, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: > Why backslash does not raise parser :error? It does: > Database: S_TEST, User: SD > SQL> Select * from rdb$relations\ R > CON> Inner join rdb$relation_fields rf on rf.rdb$relation_name =

[firebird-support] Odp: Why backlash do not raise parser error

Hi, I see that it is not sql problem only connectivity problem. Delphi Firedac remove it before executing. Regards, Karol Bieniaszewski - Reply message - Od: "liviusliv...@poczta.onet.pl" Do: Temat: Why backlash do not

[firebird-support] Why backlash do not raise parser error

Hi, Why backslash does not raise parser :error? E.g. Select * from rdb$relations\ R Inner join rdb$relation_fields rf on rf.rdb$relation_name = r.rdb$relation_name\ Where 1=1 Try first line only or whole sql. Interesting that mssql also does not raise exception. It have some reserved

Re: [firebird-support] Foreign key different field type

Well, I would hope that create procedure ... declare variable i2 TYPE OF COLUMN test2.id1; declare variable i TYPE OF COLUMN test.id; begin i2 = 12345678; i = 12345678; ... would complain about the assignment to i and not i2. Although I agree with you that it sounds rather useless to allow