We would also stop xinetd, kill existing connections, and connect to the
database locally
On Tue, Apr 16, 2019 at 6:13 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 15.04.2019 18:23, my...@techsol.org [firebird-support] wrote:
> > End users (and end user reporting applica
If I do:
SET TRANSACTION TO 300
In ExecSQL, my currenty transaction will be waitting 30 sec?
Em ter, 16 de abr de 2019 às 08:03, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escreveu:
> 15.04.2019 19:59, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> > First question:
> >
On Apr 16, 2019, at 4:40 AM, respekt...@post.cz [firebird-support]
wrote:
>
> Hi, thank you for reply
>
> But this ordering totaly damage the tree structure
>
> Because PORADI is only relative to parent node, so all child nodes starting
> with 1
>
> If I change the query as you recommend, th
15.04.2019 12:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrote:
> I'm using not the embedded mode, or ibexpert uses it? If I configure "local"
> and use the
> fbclient.dll, every password works.
If you read Release Notes for Firebird 3.0 you'll find out that "local"
there is
u
Hi, thank you for reply
But this ordering totaly damage the tree structure
Because PORADI is only relative to parent node, so all child nodes starting
with 1
If I change the query as you recommend, the set is sorted in way
1. all first nodes
2. all second nodes
3. all third nodes
.
Hi,
I've found the reason :-)
create view view_strom_pujcoven
with recursive n (ID_PUJC, NAZEV, FK_BUDOVA, PK_PUJCOVNA, PORADI,
FK_UCETNI_JEDNOTKA, JE_UK, SIGLA, JE_ONLINE, ID_BUDOVA_PUV, FK_NADR, JE_EXEMP,
uroven, razeni)
as (
SELECT ID_PUJC, NAZEV, FK_BUDOVA, PK_PUJCOVNA, PORADI, FK_UCET
15.04.2019 19:59, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> First question:
> fdconn1.Params.Values['lock_timeout']:='180';
> or
> fdconn1.Params.Values['isc_tpb_lock_timeout']:='180';
> ???
IFAIK, FireDAC can recognize both names, but value for timeout must be an
integer, not
15.04.2019 18:23, my...@techsol.org [firebird-support] wrote:
> End users (and end user reporting applications, scripts, etc.) that connect
> to this
> database are often connected when I attempt to run these maintenance tasks,
> so I can never
> get the database to go to "offline" mode because
It's your query that is wrong, it's the final result that should be
ordered, not the subselect, i.e.:
with recursive n (ID_PUJC, NAZEV, PORADI, FK_NADR, uroven)
as (
SELECT ID_PUJC,NAZEV,PORADI,FK_NADR,0 FROM def_pujc_test
WHERE fk_nadr is null
UNION ALL
SELECT dp.ID_PUJC, dp