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
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 1 FIELD_D1, FIELD_D2 FROM TABLE_D
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 (D.FI
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, D.FIELD_D2
> FROM TABLE_A A
> LEFT JO
> 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 COR
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,
DESCPROD,
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 FireBird2.5
Hello,
I have a stored procedure that takes a parameter(a1) that has length
excess of 25k. Inside this stored procedure I have declared a variable with
a query , when this parameter(a1) combined with variable total length
exceeds 32k and FB returns as error of concatenation.
Below is er