Re: [firebird-support] Can merge return AffecterRows?

2016-09-28 Thread 渡辺 watan...@noveltte.jp [firebird-support]
Thank you ,Thomas! The count is right.I feel easy. I didn't think there was other ticket. I hope Reference will be changed. Sincerely. On 2016/09/28 22:16, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > hi,I am Nobuo Watanabe. > I use FireBird 2.5.6 and

[firebird-support] I create View in FB 2.5 but does not work in FB 1.5

2016-09-28 Thread 'Israel Pinheiro' israel.ip...@gmail.com [firebird-support]
Create a view FB 2.5 but does not create in FB 1.5 Message error ==> Line 201 | Invalid Token. Dynamic SQL Error code = -104. Invalid command. Data Type unknown CREATE VIEW ESPELHO( DTMOVPROD, TIPOMOV, CODNAT, CODVENDA, CODCOMPRA, CODPROD,

Re: [firebird-support] Can merge return AffecterRows?

2016-09-28 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> hi,I am Nobuo Watanabe. > I use FireBird 2.5.6 and FireBird2.5.3. > > Firebird2.5Language Reference about 'merge command' says: > Currently, the ROW_COUNT variable returns the value 1, even if more than one > record is modified or inserted. For details and progress, refer to Tracker > ticket

Re: Re: [firebird-support] Left join derived table

2016-09-28 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Ach Arno - i see now - he need "LATERAL JOIN" your solution is good one    regards, Karol Bieniaszewski   W dniu 2016-09-28 13:30:24 użytkownik 'Arno Brinkman' fbsupp...@abvisie.nl [firebird-support] napisał:   Hi,   > SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1,

Re: [firebird-support] Left join derived table

2016-09-28 Thread 'Arno Brinkman' fbsupp...@abvisie.nl [firebird-support]
Hi, > SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2 > FROM TABLE_A A > LEFT JOIN (SELECT FIRST 1 D.FIELD_D1, D.FIELD_D2, D.FIELD_3 FROM TABLE_D D > ORDER BY D.ID DESC) D ON D.FIELD_3 = A.FIELD_3 I assume this is not what he wants. The reason is the FIRST 1 in the derived table! The

Re: [firebird-support] Left join derived table

2016-09-28 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
W dniu 2016-09-28 09:04:07 użytkownik 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support] napisał:   Hello All I'd like to ask how to get below statement working: SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2 FROM TABLE_A A LEFT JOIN (SELECT FIRST

[firebird-support] Left join derived table

2016-09-28 Thread 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support]
Hello All I'd like to ask how to get below statement working: SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2 FROM TABLE_A A LEFT JOIN (SELECT FIRST 1 FIELD_D1, FIELD_D2 FROM TABLE_D D WHERE D.FIELD_3 = A.FIELD_3 ORDER BY D.ID DESC) D ON (1=1) Firebird complains that A.FIELD_3: Column does