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
00 1.000 0.0
000 1.000 0.0000 0.
As you see:
- if I select between 01/01/2018 and 31/12/2018 the are not rows in DT
- if I select between 01/01/2017 and 31/12/2017 works fine because the
are at least 1 row in DT
Any
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.
-
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 item
on
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 Siciliano
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
IONE,
:CONTO_DESCRIZIONE
DO SUSPEND;
END^
SET TERM ; ^
If I run the select separately I obtain the right result per select.
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 solution?
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
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
:CARICO,
:SCARICO,
:SALDO,
DO SUSPEND;
END^
Thanks to all :)
--
Luigi Siciliano
--
++
Visit http://www.f
s correct progressive sum.
What I'm wrong?
Thanks
--
Luigi Siciliano
------
--
Luigi Siciliano
--
t; 0 or SCARICO > 0
Thanks
--
Luigi Siciliano
--
lds:
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 Sicili
,
NUMERO,
SERIE
How I do?
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
for 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
for 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
ng indexes ... is a good start.
This helped me to find the problem.
> Good luck.
Thank you
--
Luigi Siciliano
--
++
Visit h
seems faster and works best of the same application
that use BDE :)
Thanks to all.
--
Luigi Siciliano
--
++
Visit http://www.fi
: 2
*END*
Thanks
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
--
Luigi Siciliano
--
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 manually?
$relation_constraints
SET
rdb$constraint_name = 'MyPrimaryKeyName'
WHERE
rdb$relation_name = MyTable
AND rDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
There are contraindications?
Thanks
--
Luigi Siciliano
the name of the Primary Key I want
update.
How I can solve?
Thanks.
--
Luigi Siciliano
--
++# 43;+++
Visit http://www.firebirdsql.org
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
.
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links
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
should set it before you'll
load fbclient.dll.
In this case, I have conflict with version 2.5 (in this case nt works
fine the 2.5 version) because environment variable is in system scope.
Is there a way to set an environment variable in scope only for
application that set it?
Thanks.
--
Luigi
.
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
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 them? I need to use SYSDBA?
Thanks.
--
Luigi Siciliano
? or I have a mistake?
Thanks.
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ
in Delphi 5 + ZeosLib 6.6.6 that not are Unicode! and I cannot
immediately update my software :(
Thanks.
--
Luigi Siciliano
--
++
Visit http://www.firebirdsql.org
51 matches
Mail list logo