Not sure if this will help or not, but instead of...

> if (IdentQry->Active)
> IdentQry->Close();
> IdentQry->ParamByName("MODEL_ID")->AsInteger =
> ModelQry->FieldByName("MODEL_ID")->AsInteger;
> IdentQry->ParamByName("DOC_FILE_ID")->AsInteger =
> DocFileQry->FieldByName("DOC_FILE_ID")->AsInteger;
> IdentQry->Open();

How about...

IdentQry->BeginUpdate();
try {
IdentQry->ParamByName("MODEL_ID")->AsInteger =
ModelQry->FieldByName("MODEL_ID")->AsInteger;
IdentQry->ParamByName("DOC_FILE_ID")->AsInteger =
DocFileQry->FieldByName("DOC_FILE_ID")->AsInteger;
}
__finally {
IdentQry->EndUpdate();
};

The BeginUpdate/EndUpdate will ensure there is only one change
notification, and you dont need to explicitly close/open to achieve
the desired result.


The following has me confused...

> The Insert proc is.....
> SET TERM !! ;
> create procedure EQPT_IDENT_INSERT_PROC(IDENT_ID integer, MODEL_ID
> integer, IDENT varchar(60))

...

> I'm trying InsertSQL like.......
> INSERT INTO EQPT_IDENT(
> IDENT_ID, /*PK*/
> MODEL_ID,
> IDENT)
> VALUES (
> :IDENT_ID,
> :MODELID,
> :IDENT)

If you have an insert proc why arent you using it? I believe that you
must have intended to have in the InsertSQL was something like...

EXECUTE PROCEDURE EQPT_IDENT_INSERT_PROC(
:IDENT_ID,
:MODELID,
:IDENT )


Does this help?

--
Geoff Worboys - TeamIBO
Telesis Computing