> EIB_Statement error: "Fieldname: code not found"

Is there a lookupcombo involved somewhere?

There is still a bug in IBO4.2.Fr (arrived in IBO4.2.Fp)...

In IB_Dataset.IMP...

procedure TIB_Dataset.KeyToChildAction( AAction: TIB_KeyChildAction;
Info: longint );
<...>
ADataset.Prepare;
//TIB_Row( Info ).Values[ tmpVals ] :=
// TIB_BDataset( ADataset ).Lookup(
// tmpKeyVals,
// TIB_Row( Info ).Values[ tmpKeyFlds ], tmpFlds );
TIB_Row( Info ).Values[ tmpVals ] :=
TIB_BDataset( ADataset ).Lookup(
tmpKeyFlds,
TIB_Row( Info ).Values[ tmpKeyVals ], tmpFlds );
<...>
end;


It is just that the tmpKeyFlds and tmpKeyVals were reversed in the
call the Lookup.

hth

--
Geoff Worboys - TeamIBO
Telesis Computing