Hi *,
I'm running Firebird 2.5 x64 on Windows server. I'm starting trace
session for C:\foobar\foobar.fdb and sometimes I'm getting errors in
trace stream:
Error creating trace session for database C:\PROGRAM
FILES\FIREBIRD\SECURITY2.FDB: error while parsing trace configu
ration line 1: error
Just in case the trace configuration is:
database C:\foobar\foobar.fdb
enabled true
log_connections true
connection_id 0
...
/database
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
In a table I have records with id's 2,4,5,8. How can I receive a list with
values 1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM table t2
WHERE t2.id = t1.id + 1
)
but it's not working correctly. It doesn't bring all available
maybe help you:
http://www.xaprb.com/blog/2005/12/06/find-missing-numbers-in-a-sequence-with-sql/
In a table I have records with id's 2,4,5,8. How can I receive a list with
values 1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM
In a table I have records with id's 2,4,5,8. How can I receive a list with
values
1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM table t2
WHERE t2.id = t1.id + 1
)
but it's not working correctly. It doesn't bring all
I am try to add a string list to FB 2.5 blob field using a query within a
Delphi application. My code works great, unless the string list contains a
quoted string. How do I get around this?
Example String list:
[TatukGIS Layer]
Area.Color=$80FF
Area.OutlineColor=$10101
Area.OutlineWidth=20
Hello guys,
I've a legacy system that keeps many old active transactions and old
intersting transactions for a long time. How can I configure
firebird.conf to support 50 conections on a SuperClassic 2.5.1 and get a
better performance on a Windows Server 16GB ?
[Non-text portions of this
I've a legacy system that keeps many old active transactions and old
intersting transactions for a long time. How can I configure firebird.conf
to
support 50 conections on a SuperClassic 2.5.1 and get a better performance
on a Windows Server 16GB ?
Without a change to the behaviour of the
In a table I have records with id's 2,4,5,8. How can I receive a list
with values 1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM table t2
WHERE t2.id = t1.id + 1
)
but it's not working correctly. It doesn't bring all
SET,
In a table I have records with id's 2,4,5,8. How can I receive a list
with values 1,3,6,7. I have tried in this way
SELECT t1.id + 1
FROM table t1
WHERE NOT EXISTS (
SELECT *
FROM table t2
WHERE t2.id = t1.id + 1
)
but it's not working correctly. It
Once again, your keen I found an error!
I swear, English is my mother tongue. Although, from the above, you'd never
know it!
Once again, your keen *eye* found an error!
S
--- In firebird-support@yahoogroups.com, Ann Harrison wrote:
On Mon, Jan 28, 2013 at 2:21 PM, Jeff wrote:
High/Low is a technique of generating primary keys client side in contrast
to generating keys server side with fb generators. Here is a link to a
discussion that probably
At 09:34 a.m. 30/01/2013, Leyne, Sean wrote:
Once again, your keen I found an error!
I swear, English is my mother tongue. Although, from the above, you'd never
know it!
Once again, your keen *eye* found an error!
...and here was eye, thinking you were using Dragon NS to compose your emails!
Hello,
I'm trying to improve a setup w firebirdsql 2.1 / windows by adding some
monitoring.
Ideally, I want to use cacti (cacti.net) to graph any numbers like
mysql/postgresql [1] but it doesn't seem there is any existing stuff [2].
After looking on the net, I got a few interesting references
* other interesting requests ? to prevent or diagnose quickly problems ?
I sometimes use (well, I don't actually include any ORDER BY, but would if
there were lots of simultaneous activity going on)
select whatever
from mon$statements
where mon$transaction_id current_transaction
order by
15 matches
Mail list logo