Thanks Martijn,

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

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.
>
>
>With regards,
>
>Martijn Tonies
>Database Workbench - the developer tool for InterBase & Firebird
>Upscene Productions
>http://www.upscene.com
>
> > 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.
> > >
> > >
> > >With regards,
> > >
> > >Martijn Tonies
> > >Database Workbench - the developer tool for InterBase & Firebird
> > >Upscene Productions
> > >http://www.upscene.com
> > >
> > >
> > >To unsubscribe from this group, send an email to:
> > >firebird-support-unsubscribe@yahoogroups.com
> > >
> > >
> > >
> > >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >
> > >---
> > >Incoming mail is certified Virus Free.
> > >Checked by AVG anti-virus system (http://www.grisoft.com).
> > >Version: 6.0.489 / Virus Database: 288 - Release Date: 6/10/2003
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.489 / Virus Database: 288 - Release Date: 6/10/2003

[Non-text portions of this message have been removed]