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*
> 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
> 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
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
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
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
ABout 100 simultaneous remote users may log in and insert data in a table
via a stored procedure.
Pentium III 667/133 Mhz 1.GB Ram
WIll it be OK ?
*Kind Regards*
*Alain Bastien*
*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30*
*Skype:alainbastien*
*Viber: 7320143*