Hello!
May I use the system table MON$ATTACHMENT in order to get the connected
users in moment?
I already try to do it, but when a connection from a client (another
machine) is ended abnormally (for example, turn off the machine or
disconnect the cable of network), this connection still stay
Goodmorning,
I have to continue to work on a existing ERP program with an existing FB
database. I don't like the design very much, looks messy and the original
designer didn't think twice a lot from what I see.
Example, when I take a look at the small lookup tables used to store payment
On Mon, 10 Aug 2015 19:23:56 +, Maureen Bertocci
mberto...@bblfleet.com [firebird-support]
firebird-support@yahoogroups.com wrote:
Hello, and thank you I am excite about my new endeavor!
I would like to join the support group. I am new to firebird. There
are
two things I am trying
On 10 Aug 2015 14:23:44 -0700, email...@yahoo.com.br [firebird-support]
firebird-support@yahoogroups.com wrote:
- I add new records mannually, add one new ID field value and the other
fields have your values by TRIGGER BEFORE INSERT
- Then, I try add 2 or more record with ID = 1
- Later, I try
I believe there is no PK in the table, so engine doesn't know what record to
delete
Regards,
Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 11, 2015 12:54 PM
To: firebird-support@yahoogroups.com
Subject: Re:
On Tue, 11 Aug 2015 13:09:27 +0200, 'Bogdan' bog...@mordicom.si
[firebird-support] firebird-support@yahoogroups.com wrote:
I believe there is no PK in the table, so engine doesn't know what
record
to delete
A delete statement doesn't need an unique identification of the row (the
exception is
On Aug 11, 2015, at 4:59 AM, steve.decle...@yahoo.com [firebird-support]
firebird-support@yahoogroups.com wrote:
...when I take a look at the small lookup tables used to store payment
conditions, currency codes, titles, etc, the primary key is always
VARCHAR(4) to either store a
On Aug 11, 2015, at 12:22 PM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] firebird-support@yahoogroups.com wrote:
Sure I understand that, but the reads/fetches are 3000 to return 1 row.
Which involves a four way join, on top of having to find and use the system
tables to
Sure I understand that, but the reads/fetches are 3000 to return 1 row.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 11 August 2015 06:15 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Reads inconsistency between FB
Thanks Ann, so maybe the 2 tools' metric are different. So maybe FBTM
includes all (low level) reads and IP only user table reads.
My other question is why is there 'WARNING' against some of the indexes? Are
the stats out of spec?
From: firebird-support@yahoogroups.com
On Aug 11, 2015, at 1:30 PM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] firebird-support@yahoogroups.com wrote:
Thanks Ann, so maybe the 2 tools' metric are different. So maybe FBTM
includes all (low level) reads and IP only user table reads.
Or maybe one runs some queries
Dear All,
I have a question. I need to store some data in Firebird database. One of
the data is a running serial number, 0 to 99. I try the Count SQL
function, but sometimes after INSERT function I get same number 2-3 times.
After I try to make a tabel which contain an INTEGER field, and I
Dear All,
I have a question. I need to store some data in Firebird database. One
of the data is a running serial number, 0 to 99. I try the Count SQL
function, but sometimes
after INSERT function I get same number 2-3 times. After I try to make
a tabel which contain an INTEGER field, and
Also, if I remove the order by, IP reports a drastic reduction is
execution time i.e. down to 6msec. Does the ORDER BY on the PK make
such a
difference?
Unh, maybe. Between the list, my mail system and yours, I've lost
most of the formatting and can't look at the original while typing
14 matches
Mail list logo
