At 11:32 AM 13-10-02 -0400, you wrote:

> >>To state the obvious, it looks as if you are trying to stuff a value into
>a
> >>column in the new table that violates a uniqueness constraint. What's the
> >>question?
>
>True, except the table is empty.

The table will stay empty until the transaction is committed. The
transaction won't be able to commit if there is a PK violation - so, in the
cache you have a set of rows containing one which has the same key as the
one upon which the exception is raised.

If a generator is involved, you might get a clue by inspecting its current
value...

Does that help to answer the question you didn't ask? :-))

Helen

>Marv
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/