Tomasz,
> One of the legacy databases I happen to maintain has character sets and
> collations messed up. [...]
For a database that is messed up like this, I'd go the clean way and
use a pump. That would also give you the opportunity to change it to
Unicode (UTF-8) at the same time, which is a tr
> Does it apply to remote servers also such as
> www.myserver.com:/opt/database/fbdata.fdb
> The release note README file in the embbeded zip says:
> [...]
You are mixing up access to a remote database (only fbclient.dll
needed) and the Embedded Firebird server (fbembed.dll, renamed to
fbclient.dl
Hi All,
The second code fragment works like a charm (the transaction started
properly with the given parametes). The first not and return this error
message:
"invalid format for transaction parameter block
-wrong version of transaction parameter block"
What's wrong with the IXpbBuilder?
*1*
v
> I have INSERT about 10 records in a Table, the size of the FB Database
> grew up to 15MB
> I DELETE the records the size remains 15MB.
That is normal. A Firebird database is organized in pages that are
allocated when needed. When you delete the records, the pages will be
marked as free and
> 29.08.2016 10:24, patrick_mar...@yahoo.com [firebird-support] wrote:
>> Somehow I've thought that an after update trigger only fires once when all
>> the changes
>> have been made and comitted.
>DML triggers are fired on every change of every record.
And they fire BEFORE the **transaction
29.08.2016 10:24, patrick_mar...@yahoo.com [firebird-support] wrote:
> Somehow I've thought that an after update trigger only fires once when all
> the changes
> have been made and comitted.
DML triggers are fired on every change of every record.
--
WBR, SD.
---
Hi guys,
thanks for the suggestions and ideas, it helped to track it down.
It was not directly another trigger or procedure updating the record in
question, but something similar :
I had altered an existing trigger. There was an if-block checking a field A for
being not null and executing some
On 29/08/2016 00:28, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] wrote:
What’s performance like?
So far I have only tested with a very limited set of data (approx. 30
records) so haven't noticed any performance issues. FlameRobin reports
sub 0.01s times!
The maximum number o
I have INSERT about 10 records in a Table, the size of the FB Database
grew up to 15MB
I DELETE the records the size remains 15MB.
After BACKUP and RESTORE thru FlameRobin then the size was reduce to 788Kb
Is this normal ? or can it me done automatically within the settings and
configs
*
