Hi Tim,

> What I cannot understand is that it's happening on an insert?

With only this information - me neither :-)

Explain a bit more. Are there triggers, for example.

Post your complete DDL for the objects involved and what
you're doing.

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> Tim
>
> At 04:21 PM 6/17/2003 +0200, you wrote:
>
> >Hi Tim,
> >
> > > Is this field level, record level or table level?
> >
> >As far as I know, Firebird doesn't have table-level
> >locks, but only record-level locks.
> >
> >
> > > At 04:13 PM 6/17/2003 +0200, you wrote:
> > >
> > > >Hi Tim,
> > > >
> > > > > I am getting the following error :
> > > > >
> > > > > "lock conflict on no wait transaction"
> > > > >
> > > > > What causes it? How can I resolve it?
> > > >
> > > >It's caused by a deadlock:
> > > >
> > > >1 transaction having changed a record but not committed yet,
> > > >and another transaction attempting to change this record as well.