Hi,
better is walk throught tree
--
WITH RECURSIVE
R_TREE AS
(
SELECT TT.ID, TT.ID AS TOP_PARENT
FROM TABLE1 TT
WHERE TT.PARENT_ID IS NULL
UNION ALL
SELECT TT.ID, RT.TOP_PARENT
FROM TABLE1 TT JOIN R_TREE RT ON RT.ID =
2018. 05. 30. 16:51 keltezéssel, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] írta:
> Recursive CTEs always make my head hurt, but if I understand the intent
> correctly, you should replace it with:
>
> select ti.id, t.parent_id
> from table1 t
> inner join table1 root on t.parent_id =
__ Information from ESET Mail Security, version of virus signature
database 17471 (20180530) __
The message was checked by ESET Mail Security.
http://www.eset.com
On 30-5-2018 14:41, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> 2018. 05. 29. 19:08 keltezéssel, Omacht András aoma...@mve.hu
> [firebird-support] írta:
>> Hi Gabor!
>>
>> You can do it with recursive cte:
>
>
> First of all, thank you very much! But...
>
> I got "multiple rows in
2018. 05. 30. 16:04 keltezéssel, Omacht András aoma...@mve.hu
[firebird-support] írta:
> Hi Gábor!
>
> Now I can only test on 2.5.8, and it works:
András,
I tried now with 2.5.8 and got same error as with 3.0.3. Your TABLE1
contains all 12 rows?
Gabor
resources/documents/
++
Yahoo Groups Links
__ Information from ESET Mail Security, version of virus signature
database 17470 (20180530) __
The message was checked by ESET Mail Security.
2018. 05. 29. 19:08 keltezéssel, Omacht András aoma...@mve.hu
[firebird-support] írta:
> Hi Gabor!
>
> You can do it with recursive cte:
First of all, thank you very much! But...
I got "multiple rows in singleton select multiple rows in singleton
select" (yes, double) error message with my
Ach... thanks
"%FB_DIR%\gbak" -service 127.0.0.1:service_mgr -c -v -BUFFERS 0 -STATISTICS TD
-user SYSDBA -password masterkey
%FB_BACKUP%\security3.bak%FB_RESTORE%\security3.fdb.restored >
%FB_RESTORE%\rest.security3.rep 2>&1
regards,
Karol Bieniaszewski
W dniu 2018-05-30
30.05.2018 10:45, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> it redirect info to the file but errors are not redirected - why?
You forgot ">" before "%FB_RESTORE%\rest.security3.rep".
--
WBR, SD.
Hi,
how to redirect output of gbak to the file?
"%FB_DIR%\gbak" -service 127.0.0.1:service_mgr -c -v -BUFFERS 0 -STATISTICS TD
-user SYSDBA -password masterkey %FB_BACKUP%\security3.bak
%FB_RESTORE%\security3.fdb.restored 2>&1
10 matches
Mail list logo