ect 3 on FB 2.5.8.27089
Luigi Siciliano
--
Hallo,
Il 03/07/2019 16:35, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] ha scritto:
What are the exact types of both fields?
NUMERIC(18,4) via domain:
CREATE DOMAIN CURRENCY_D
AS Numeric(18,4)
DEFAULT 0.00
NOT NULL
;
Thanks.
--
Luigi Siciliano
--
ECIMAL(18,2))
the result of the query changes but is a mistake because the result must
be _no rows_ :
ID IMPORTO PAGATO
29 60,00 60,00
90 569,83 569,83
Why?
Thanks.
--
Luigi Siciliano
--
that M$ SqlServer don't works like Firebird).
I need to reinstall Windows 8.1 (build 6.3.9600) but after download at
microsoft.com site during install at 72% except a error that a file (not
specified) is missing or damaged and stop installation :(
Thanks.
--
Luigi Siciliano
--
I tried to copy all my databases in another system and with the same
server version 2.5.8.27089 and the same Flamerobin version 0.9.2 the
databases opens and i can read all tables.
What I can verify on system that cannot open databases?
Thanks
--
Luigi Siciliano
t I can do?
--
Luigi Siciliano
--
even I have hundred rows in table
that fire a before insert/update trigger and if the exception occurs in
hundredth row? or trigger is fired row by row in table and this
behaviour not occurs and the update made by row 1..99 are confirmed even
occurs an exception in row 100?
Thanks.
--
Luigi Siciliano
--
another table from a Before trigger is made in a transaction
that rolling back if exception occurs?
Thanks.
--
Luigi Siciliano
Hallo,
Il 04/01/2018 21.57, setysvar setys...@gmail.com [firebird-support] ha
scritto:
I expect the following query to give you the result
you want:
...
Yes.
I think I understand your query and I'll treasure it for the next time.
Thanks so much.
--
Luigi Siciliano
--
not, I not solved ;(
The query seem to works because return rows but the rows returned are
wrongs.
--
Luigi Siciliano
--
SUM(DC.ORDINATI) as Ordinati
FROM
DEPOSITI D
LEFT JOIN DOC_TESTA DT ON D.ID = DT.DEPOSITO_ID,
DOC_CORPO DC
WHERE
DC.ARTICOLO_ID = :ID
AND DT.DATA >= :DaData
AND DT.DATA <= :AData
GROUP BY
D.ID
)
Thanks.
--
Luigi Siciliano
--
I expecting the result because in table Doc_testa DT I have rows between
01/01/2017 and 31/12/2017 and not have rows between 01/01/2018 and
31/12/2018.
--
Luigi Siciliano
Hallo,
Il 04/01/2018 16.58, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] ha scritto:
> 04.01.2018 16:55, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
> wrote:
>> As you see:
>> - if I select between 01/01/2018 and 31/12/2018 the are not rows in D
= === ===
1 0.0000 1.000 0.0
000 1.000 0. 0.
As you see:
- if I select between 01/01/2018 and 31/12/2018 the are not rows in DT
-
NZA,
SUM(DC.IMPEGNATI) as Impegnati,
SUM(DC.ORDINATI) as Ordinati
FROM
DOC_CORPO DC, DOC_TESTA DT
WHERE
DC.DOC_TESTA_ID = DT.ID
AND DC.ARTICOLO_ID = :ID
AND DT.DATA >= :DaData
AND DT.DATA <= :AData
GROUP BY
DT.DEPOSITO_ID
)
How I can modify it?
Thanks.
-
(PNC NATURAL, PNT INDEX (PN_TESTA_PK), C INDEX (PK_CLIENTI),
PNS INDEX (PN_SCADENZE_FK))
With Set suggestion:
PLAN (PNC2 NATURAL)
PLAN JOIN (PNC NATURAL, PNT INDEX (PN_TESTA_PK), C INDEX (PK_CLIENTI),
PNS INDEX (PN_SCADENZE_FK))
Thanks.
--
Luigi Siciliano
--
manually maintenance for it's?
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation it
08s
Script execution finished
How I can speed up it?
The time 1.608s if referred at only 300 rows fetched as defaults of
flamerobin. In production I have 1157 rows affected (they grows rapidly)
in near 6.20s.
Thanks
--
Luigi
Ok, I find my mistake:
It is necessary add a line SUSPEND after DO before the second FOR SELECT
like this:
FOR SELECT
DO *SUSPEND*
FOR SELECT
Thanks.
--
Luigi Siciliano
LE_DESCRIZIONE,
:CONTO_DESCRIZIONE
DO SUSPEND;
END^
SET TERM ; ^
If I run the select separately I obtain the right result per
OIN PN_CORPO PNC on PNT.ID = PNC.PN_TESTA_ID
WHERE
PNC.CONTO_ID = :CONTO
if :CLIENTE is not null then <-- *IS NOT ACCEPTED*
AND IIF (PNC.CLIENTE_ID IS NOT NULL, PNC.CLIENTE_ID,
PNC.FORNITORE_ID) = :CLIENTE)
There's a soluti
e the question:
what is more performant: "EXTRACT (YEAR FROM DT.DATA) <= 2016" or
"DT.DATA <= '12/31/2016'"?
I would prepare myself for a table that grows rapidly.
Is the same in FB 2.5.6 or 3.0.1?
Thanks
--
Luigi Siciliano
--
Hallo,
what is more performant from subject?
I would prepare myself for a table that grows rapidly.
Is the same in FB 2.5.6 or 3.0.1?
Thanks
--
Luigi Siciliano
single user you basically can't distinguish people on the
server side through CURRENT_USER etc.
I have however, suggested to everyone to change this behaviour and
connect to Firebird database with the username assigned them by the
Database Administrator.
Thanks
--
Luigi Siciliano
--
Hello,
If a user try to connect from two or more PC with same username,
Firebird accepts the connection but is safe without problems or is best
to avoid like the pest?
Thanks.
--
Luigi Siciliano
:SERIE,
:CARICO,
:SCARICO,
:SALDO,
DO SUSPEND;
END^
Thanks to all :)
--
Luigi Siciliano
--
++
Visit h
Hallo,
Il 08/03/2016 11.24, Aage Johansen aagjo...@online.no [firebird-support]
ha scritto:
You could try
coalesce(sum(DC2.CARICO-DC2.SCARICO),0) as SALDO
In this case I obtain that the SALDO field reports 0 instead of null.
Thanks.
--
Luigi Siciliano
--
;m not sure if you should add DC.DOC_TESTA_ID to the order clause.
If that works you should also do an ORDER BY in the sub-select)
If I understand correctly, not works.
Thanks
--
Luigi Siciliano
--
s correct progressive sum.
What I'm wrong?
Thanks
--
Luigi Siciliano
------
--
Luigi Siciliano
--
+++
t; 0 or SCARICO > 0
Thanks
--
Luigi Siciliano
--
s fields:
DATA DOCUMENTO_ID NUMERO SERIE CARICO SCARICO
I need add SALDO fields in the result of the query to get a progressive
sum of CARICO - SCARICO.
Thanks
--
Luigi S
,
NUMERO,
SERIE
How I do?
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
trigger CHECK_33 in RDB$TRIGGERS is corrupted (304)
RDB$FLAGS for trigger CHECK_34 in RDB$TRIGGERS is corrupted (304)
RDB$FLAGS for trigger CHECK_35 in RDB$TRIGGERS is corrupted (304)
RDB$FLAGS for trigger CHECK_36 in RDB$TRIGGERS is corrupted (304)
What I will investigate?
Thanks
--
Luigi
trigger CHECK_33 in RDB$TRIGGERS is corrupted (304)
RDB$FLAGS for trigger CHECK_34 in RDB$TRIGGERS is corrupted (304)
RDB$FLAGS for trigger CHECK_35 in RDB$TRIGGERS is corrupted (304)
RDB$FLAGS for trigger CHECK_36 in RDB$TRIGGERS is corrupted (304)
What I will investigate?
Thanks
--
Luigi
Hallo,
Il 29/02/2016 17.51, Fernando P. Nájera Cano y...@fernandonajera.com
[firebird-support] ha scritto:
> When you do SUM(DC.I / DC.Q), the value of the division is calculated
> *per row*, and then those values are summed up.
>
> Fernando Nájera
Ok, now I understand.
Thank Yo
Hallo,
Il 29/02/2016 15.31, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] ha scritto:
> 29.02.2016 15:19, Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
> wrote:
>> What is the difference from "SUM(DC.I) / SUM(DC.Q)"
>> and "SUM(DC.
t;SUM(DC.I / DC.Q)"
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
on the mai
accidentally execution of the trigger.
How I can do this?
I need a After Insert/Update trigger? But in this case I implement a
recursive loop Before-After Insert/Update Trigger?
Thanks
--
Luigi Siciliano
arn if is possible the other one (C * A as D)
Thanks.
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Docume
seems faster and works best of the same application
that use BDE :)
Thanks to all.
--
Luigi Siciliano
--
++
Visit http://www.fi
ng to missing indexes ... is a good start.
This helped me to find the problem.
> Good luck.
Thank you
--
Luigi Siciliano
--
++
--
Luigi Siciliano
--
: 2
*END*
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
assign the
number to be sure of not have a hole in numeration?
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org
.
Why during installation this file is not copied in windows directory?
This file is needed to copy to C:\WINDOWS only manual
$relation_constraints
SET
rdb$constraint_name = 'MyPrimaryKeyName'
WHERE
rdb$relation_name = MyTable
AND rDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
There are contraindications?
Thanks
I cannot use the instruction above because I don't know in all
production databases of my customers the name of the Primary Key I want
update.
How I can solve?
Thanks.
--
Luigi Siciliano
--
nt database file.
I cannot use the instruction above because I don't know in all
production databases of my customers the name of the Primary Key I want
update.
How I can solve?
Tha
esults: ANNO, IMPONIBILE, IMPOSTA?
Thanks.
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
Hallo,
Il 22/02/2014 22.41, hv...@users.sourceforge.net ha scritto:
Sounds crazy, sorry. Can you provide a reason for it ? Just curious...
I have a component thath not works on unicode :-(
Sure. You can
a) run your application using bat\cmd file with two lines
SET FIREBIRD_MSG=
application that set it?
Thanks.
--
Luigi Siciliano
--
.
If I put firebird.msg in Windows\system I create a conflict by different
versions of clients (2.1 + 2.5).
There is a way to put firebird.msg for 2.1 version in a directory that
not conflict with the one for version 2.5?
Thanks.
--
Luigi Siciliano
ault super-user of
Firebird and the user with it can do everything.
Is this right?
Then, I need to create the users "MyAdminX" and "MyAppAdministrator" in
the system of my user during installation of my application.
How can i create t
st use it by my software
written in Delphi 5 + ZeosLib 6.6.6 that not are Unicode! and I cannot
immediately update my software :(
Thanks.
--
Luigi Siciliano
--
++
ed procedures.
Is this a bug? or I have a mistake?
Thanks.
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) men
Hallo,
I need to install into a PC with Win 8.1 + FB 2.5.2.2640 an
application that use FBClient 2.1 version (is not possible to update
this application to use 2.5 version).
Is it possible and safe?
I tried a little and seem to work but, what problems I expect?
Thanks.
--
Luigi
---
56 matches
Mail list logo