Hello Thomas,
the result set contains 3 record for criteria.
Records DATUM >= '5.10.2015' = 102
Records DATUM <= '11.10.2015' = 26
It seems that both queries need to be executed and then the subset of
matching data for both date conditions is provided.
The performance is not my main concern in
Hi,
the execution is currently not the problem, because the number of records is
too small.
I have the impression that the first query looks for DATUM >= x and the
second one for DATUM <= y and finally delivers the number of records that is
included in both result sets.
My main interesst is to u
Hello,
there are two indices on the field DATUM: One ascending, the other one
descending.
Plan:
PLAN (A INDEX (IDX_ARBEITSEINTEILUNG1))
Adapted plan:
PLAN (A INDEX (IDX_ARBEITSEINTEILUNG1))
Niko
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Ges
Hello all,
i am running a simple query where the result contains 3 records. The query
should provide all records in a specific week.
SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND WOCHE =
'2015-41';
Some times I dont have a week but two dates:
In this case - th
Hello,
my customer base is running Firebird 2.5.0 (32bit), some on 2.5.3 (64bit)
and others on 2.5.4 (64bit).
I am using always gbak form 2.5.0 32bit to start local backups for support
purpose: The customers send me the latest backup, I import them and analyze
the issue.
Is there anyth
german characters
Niko,
'Parzival' parzival1...@gmx.at [firebird-support] schrieb am 02.06.2015
22:12:
> Hello all,
>
>
>
> for updating some tables at customers I create SQL scripts and execute
them
> with ISQL i parameter. This works perfect unless I hav
Hello all,
for updating some tables at customers I create SQL scripts and execute them
with ISQL i parameter. This works perfect unless I have to insert german
special characters like äöüß.
The database is set to ISO8859_1.
Even when I set the charset with charset for the command li
Hello Ann,
I am not 100% sure that I fully understood your message. Emils question seem to
be very similar to mine, only he uses Linux to run Firebird. I read your answer
to Emil that it is ok and safe.
The share Z:\mysharedfolder\mydb.fdb is a folder on fileserver with the
Firebird Ser
Hello,
I am running Firebird 2.5.0 on Windows for some time on several customer
locations. When the client and the server are in the same network the
performance is good. It gets difficult when a more complex network structure
(eg. Access via VPN) is in place. I see then error 10054 in the fire
Hello Martijn,
my impression was the other way arround ;-)
When I change the charset in isql to any charset, that is definitly not used in
the database I always get the same output from isql. I was expecting that the
presentation of the same data (= varchar with special characters) would
Hello,
due to an import problem the database contains some records with wrong
special characters.
The database runs on ISO8859_1. When I select the records in EMS SQL Manager
(also configured for ISO8859_1) it shows following data:
Kcher
Sttzen
Trger
In ISQL (isql localhost:myDB -
11 matches
Mail list logo