help in database updations.

Hi all,

Let me first explain what I am trying to do. I have a web app, where from my
asp page, i call a stored procedure.

Now this page is used by N users concurrently. This SP updates a table,
updates a second table with first as ref,

and clear first table. in between there is a delay of few seconds, which i
have explicitly put( waitfor delay command)


but teh problem appears when some users at the same time use this page, and
update table, then the records by only one user are present in the table,
the same for all teh other users are found missing later.

why are the updations made by the other users not updated in the second
table?

what am I missing here?

TIA.

Alan
Fri May 07 00:15:29 CDT 2004

Post your code.





"SPG" <not@noreply.com> wrote in message
news:e8QgnC$MEHA.1392@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> Let me first explain what I am trying to do. I have a web app, where from
my
> asp page, i call a stored procedure.
>
> Now this page is used by N users concurrently. This SP updates a table,
> updates a second table with first as ref,
>
> and clear first table. in between there is a delay of few seconds, which i
> have explicitly put( waitfor delay command)
>
>
> but teh problem appears when some users at the same time use this page,
and
> update table, then the records by only one user are present in the table,
> the same for all teh other users are found missing later.
>
> why are the updations made by the other users not updated in the second
> table?
>
> what am I missing here?
>
> TIA.
>
>

SPG
Fri May 07 00:40:31 CDT 2004

Thanks Alan, I will post it in a while. Please help me here.

"Alan Howard" <Xalan.howardX@Xparadise.net.nzX> wrote in message
news:OpKI4K$MEHA.2532@TK2MSFTNGP10.phx.gbl...
> Post your code.
>
>
>
>
>
> "SPG" <not@noreply.com> wrote in message
> news:e8QgnC$MEHA.1392@TK2MSFTNGP09.phx.gbl...
> > Hi all,
> >
> > Let me first explain what I am trying to do. I have a web app, where
from
> my
> > asp page, i call a stored procedure.
> >
> > Now this page is used by N users concurrently. This SP updates a table,
> > updates a second table with first as ref,
> >
> > and clear first table. in between there is a delay of few seconds, which
i
> > have explicitly put( waitfor delay command)
> >
> >
> > but teh problem appears when some users at the same time use this page,
> and
> > update table, then the records by only one user are present in the
table,
> > the same for all teh other users are found missing later.
> >
> > why are the updations made by the other users not updated in the second
> > table?
> >
> > what am I missing here?
> >
> > TIA.
> >
> >
>
>

Andrew
Fri May 07 02:44:08 CDT 2004

SPG,

Agree - post your code if you want help with it.

Some comments in line:

"SPG" <not@noreply.com> wrote in message news:e8QgnC$MEHA.1392@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> Let me first explain what I am trying to do. I have a web app, where from my
> asp page, i call a stored procedure.
>
> Now this page is used by N users concurrently. This SP updates a table,
> updates a second table with first as ref,
>
> and clear first table. in between there is a delay of few seconds, which i
> have explicitly put( waitfor delay command)

Are ye mad ! A waitfor delay command has no place there. The cure is FAR worse
than the disease.

>
>
> but teh problem appears when some users at the same time use this page, and
> update table, then the records by only one user are present in the table,
> the same for all teh other users are found missing later.
>

Need to read up on concurrency and record locking.


> why are the updations made by the other users not updated in the second
> table?
>
> what am I missing here?
>
> TIA.
>
>