I'm using WI-T6.2.679 Firebird Release Candidate 2 on Win2k with Access as a
client. Not using the client just yet though - working with Firebird using
Interbase Workbench.

I created a test database newbie.gdb with 2 tables...

here are the db properties, I'm including them since when I viewed them I
noticed that Page Buffers were set to 0 and the minimum is 50 - so I set it
to 50.

Database: boognish:C:\Firebird\data\newbie.gdb
Character Set: NONE
Version: WI-T6.2.679 Firebird Release Candidate 2
ODS Version: 10.0
Page Size: 4096
Allocated Pages: 154
Size in Pages: 154
Page Buffers: 50
SQL Dialect: 3
Sweep Interval: 20000
Forced Writes: enabled
Read Only: disabled

the DLL for the tables:

RECREATE TABLE EMP_TRANSACTION
(
TID INTEGER NOT NULL,
ID INTEGER,
F_NAME VARCHAR( 20) CHARACTER SET NONE COLLATE NONE,
L_NAME VARCHAR( 40) CHARACTER SET NONE COLLATE NONE,
TITLE VARCHAR( 40) CHARACTER SET NONE COLLATE NONE,
HIRE_DATE VARCHAR( 10) CHARACTER SET NONE COLLATE NONE
);
COMMIT;

RECREATE TABLE EMPLOYEE
(
ID INTEGER NOT NULL,
F_NAME VARCHAR( 20) CHARACTER SET NONE COLLATE NONE,
L_NAME VARCHAR( 40) CHARACTER SET NONE COLLATE NONE,
TITLE VARCHAR( 40) CHARACTER SET NONE COLLATE NONE,
HIRE_DATE VARCHAR( 10) CHARACTER SET NONE COLLATE NONE
);
COMMIT;

Trigger:


I'm trying to figure out if my code is erroneous or if I have bigger,
configuration related problems.