On 31 Oct 2001, at 22:22, Jason Wharton wrote:

> > I have a table on a form and I use locking. As soon as the table is
> > posted I execute a procedure to duplicate that record and then
> > update the previously locked record, and I'm getting deadlock
> > exception.
> >
> > The table on form is in browse mode before the stored procedure is
> > called.
> >
> > Any idea why I'm having a deadlock?
>
> Because you are doing it in two separate transaction contexts.

But the table is in browse mode when I call the StorProc

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz