Hi Folks:

Developing C++ on Windows XP MediaCenter with VC6. Using
Firebird Super Server 2.0.1 and IBPP 2.5.3.1. The Firebird
server software is running on the same machine as the
application.

I'm getting this error message:

"violation of FOREIGN KEY constraint "INTEG_31" on table "INC"
Foreign key reference target does not exist"

There is also a complaint about a deadlock, and Firebird seems
to wait for about 10 seconds to report the problem. So, I'm not
sure what's going on.

The event table, with the foreign key, is created like this:

CREATE TABLE EV
(
EV_KEY BIGINT NOT NULL,

.
.
.

PRIMARY KEY
(
EV_KEY
)
);

I've simplified the INC table, that has the reference
to the foreign key. This is the whole CREATE TABLE SQL:

CREATE TABLE INC
(
INC_KEY BIGINT NOT NULL,
INC_EVENT BIGINT NOT NULL REFERENCES EV(EV_KEY),
PRIMARY KEY
(
INC_KEY
)
);

I open a dialog and fill in data for EV table, then
open a dialog and fill in data for the INC table.

After returning from the INC dialog, and saying OK to
the EV dialog, a record is added to the EV table, it's
primary key is recorded, and the record is added to the
INC table, with the EV_KEY matching the record just added
to the EV table.

Here is an entry being added to the EV table:

INSERT INTO EV(
EV_KEY,

.
.
.

)
values
(
'2',

.
.
.

)

Single stepping shows the INSERT INTO EV statement being
prepared and executed without problems.

Here is the error, with the whole message and the
offending SQL:

Message: isc_dsql_execute2 failed

SQL Message : -913
deadlock

Engine Code : 335544336
Engine Message :
deadlock
violation of FOREIGN KEY constraint "INTEG_31" on table "INC"
Foreign key reference target does not exist

Error for this SQL statement

INSERT INTO INC(
INC_KEY,
INC_EVENT
)
values
(
'2',
'2'
)

These are being pulled from a log file that records
each transaction, when debugging, and the event table
has a row inserted with an EV_KEY of '2'.

I've stepped through the insertion the entry for the
EV table seems to be processed just fine, without throwing
any exceptions.

As mentioned earlier, the debugger shows a pause of about
10 seconds after the INC table's st->Execute(), which is an
IBPP statement.

What am I doing wrong?

Thanks
Larry