more ideas
at the moment.
have a good one
Tomasz
--
__--==--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==--__
__ Information from ESET Mail Security, version
==--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==--__
__ Information from ESET Mail Security, version of virus signature
database 18037 (20180912) __
The mes
On 12.09.2018 at 15:04, Svein Erling Tysvær setys...@gmail.com
[firebird-support] wrote:
> Why wouldn't my suggestion work, Tomasz? When Karol inserts his first row
> into his main table it will contain DATE_FROM 2018-09-10 and DATE_TO
> 2018-09-20 and the trigger would insert 11 rows (one for
I'm transferring many tables (967) from single BDE .DBF files (old
driver DbIV) to Firebird 2.5.
I utilize Delphi 7 as environment and ZEOS components to Firebird
connections: the work is enough easy.
A large number of old queries contain UNIONS and JOINS of tables (->
single files .DBF), but
y, version of virus signature
database 18037 (20180912) __
The message was checked by ESET Mail Security.
http://www.eset.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
_
On 12.09.2018 at 14:40, Omacht András aoma...@mve.hu [firebird-support]
wrote:
> [...]
>while (curr_date <= new.date_to) do
>
> begin
>
>insert into reserved_date (res_date) values (:curr_date);
>
>curr_date = dateadd(1 day to curr_date);
>
> end
>
> end
On a
> how to identify that connection use WireCompression effectively?
See http://tracker.firebirdsql.org/browse/CORE-5536
http://tracker.firebirdsql.org/browse/CORE-5536 and
http://tracker.firebirdsql.org/browse/CORE-5601
http://tracker.firebirdsql.org/browse/CORE-5601
Hope it
--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==--__
__ Information from ESET Mail Security, version of virus signature
database 18037 (20180912) __
The message was checked by ESET Mail Security.
http://www.eset.com
[Non-te
> According to the documentation
> (https://firebirdsql.org/refdocs/langrefupd20-get-context.html) I can retrive
> the transaction’s isolation level: > select rdb$get_context('SYSTEM',
> 'ISOLATION_LEVEL') from rdb$database
>
> But I need to know the access mode too. Is this possible
11.09.2018 10:43, 'Stellarancia.com' ni...@stellarancia.com [firebird-support]
wrote:
> Do you have any suggestion as to how to solve this problem?
Put both tables into one database.
--
WBR, SD.
Yes, it help me.
I can obtain this info on client side
And i can store this info into separate table to simply obtain on the server
side.
In Fb4 i see this will be simpler.
regards,
Karol Bieniaszewski
Od: hv...@users.sourceforge.net [firebird-support]
Wysłano: środa, 12 września 2018 18:19
Hi,
is there a good way to prevent overlaping dates to be inserted to the table?
You know DATE_FROM, DATE_TO and you can have
2018-09-10 to 2018-09-20
and
2018-09-15 to 2018-09-22
they ovelap on 15,16,17,18,19 and 20
No my real sample but simple to understand is:
customer and meeting
commit and user2 commit, then overlaping dates can
be inserted into database.
regards,
Karol Bieniaszewski
__ Information from ESET Mail Security, version of virus signature
database 18037 (20180912) __
The message was checked by ESET Mail Security.
http://www.eset.com
[Non
On 12.09.2018 at 13:29, Omacht András aoma...@mve.hu [firebird-support]
wrote:
> Create a (reserved_dates) table with date field, and make that field unique..
> When a user inserts a date into the reservation table a trigger immadiate
> inserts this date to the reserved_dates table too. Then
What about a separate table for dates with one row per date and a UNIQUE
constraint that you populate from a (AFTER INSERT/DELETE) trigger on your
real table?
HTH,
Set
Den ons. 12. sep. 2018 kl. 11:49 skrev liviuslivius
liviusliv...@poczta.onet.pl [firebird-support] <
Why wouldn't my suggestion work, Tomasz? When Karol inserts his first row
into his main table it will contain DATE_FROM 2018-09-10 and DATE_TO
2018-09-20 and the trigger would insert 11 rows (one for each date) into my
suggested table. When the next row is inserted with DATE_FROM 2018-09-15
and
Hi,
but this require to have table with all dates. 365 rows per year per customer.
This is not possible solution. This sample with customers was only
simplification. But extend this sample to meeting time date with time. This
table will be too huge...
Regards,Karol Bieniaszewski
null
On 12.09.2018 at 14:40, Omacht András aoma...@mve.hu [firebird-support]
wrote:
> Tested on 2.5.8, dialect 1:
>
>
>
> CREATE TABLE RESERVED_DATE (
>
> RES_DATE DATE NOT NULL
>
> );
>
> ALTER TABLE RESERVED_DATE ADD CONSTRAINT RESERVED_DATE_PK PRIMARY KEY
> (RES_DATE);
>
>
>
>
SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==--__
__ Information from ESET Mail Security, version of virus signature
database 18037 (20180912) __
The message was checked by ESET Mail Security.
http://www.eset.com
[Non-text portions of this message have been removed]
Hi,
how to identify that connection use WireCompression effectively?
I need to get that info:
1. from client application side
2. from server side
regards,
Karol Bieniaszewski
for a lot of transactions (because
of the full database lock while it's processing).
Thanks,
András
__ Information from ESET Mail Security, version of virus signature
database 18037 (20180912) __
The message was checked by ESET Mail Security.
http://www.eset.com
Hi,
is there a good way to prevent overlaping dates to be inserted to the table?
You know DATE_FROM, DATE_TO and you can have
2018-09-10 to 2018-09-20
and
2018-09-15 to 2018-09-22
they ovelap on 15,16,17,18,19 and 20
No my real sample but simple to understand is:
customer and meeting
22 matches
Mail list logo