Thanks Martin. This means it doesn't read uncommitted transactions?

At 01:28 PM 06/20/2003 +0200, you wrote:

> > I am a bit concerned at using snapshot - isn't that like doing a dirty
>read?
>
>Not at all - Firebird doesn't support dirty reads.
>
>Snapshot means so much as a frozen view upon the data, which, I think,
>sounds exactly like what you need :)
>
>
>With regards,
>
>Martijn Tonies
>Database Workbench - the developer tool for InterBase & Firebird
>Upscene Productions
>http://www.upscene.com
>
> > At 01:04 PM 06/20/2003 +0200, you wrote:
> >
> > >Hi Tim,
> > >
> > >
> > > > Checked with the development manager. What seems to be happening is
>that a
> > > > select query is run against the DB, with txn isolation of read
> > >consistency.
> > >
> > >You might want to try an isolation of "snapshot" - this shouldn't block
> > >any readers of the data.
> > >
> > > > When we try to make a sale (txn isolation of write consistency ) or
>close
> > >a
> > > > shift, the sale or shift txn waits until the select is closed. In
>other
> > > > words, doing a select with read consistency seems to lock the record
>set
> > > > returned by the query.
> > >
> > >
> > >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: 06/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: 06/10/2003

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