connection.execute = asynchronous process ??

[Jill Graham]

Hi,


I'm using an access database and found following problem :

I have a table X with 2 records : record 1 & record 2. I execute following
procedure with 2 steps :
1. The procedure deletes records 1 : connection.execute "delete from X
record 1"
2. The procedure adds record 1 again using the recordset object.

Result : nothing happens !
I have the feeling that the "delete" statement is executed AFTER the "add
record" statement. Or the "delete" statement did not finish before the
start of the "add record" statement (= asyncrhonous processing).

Can somebody explain me this behavior ?
I have this problem only when using a MS Access database and not with an MS
SQL database.

Jill

[Jill Graham]

Hi,


I'm using an access database and found following problem :

I have a table X with 2 records : record 1 & record 2. I execute following
procedure with 2 steps :
1. The procedure deletes records 1 : connection.execute "delete from X
record 1"
2. The procedure adds record 1 again using the recordset object.

Result : nothing happens !
I have the feeling that the "delete" statement is executed AFTER the "add
record" statement. Or the "delete" statement did not finish before the
start of the "add record" statement (= asyncrhonous processing).

Can somebody explain me this behavior ?
I have this problem only when using a MS Access database and not with an MS
SQL database.

Jill

[Ray at]

Can you show your code?

Ray at work

"Jill Graham" <jills_graham@yahoo.com.au> wrote in message
news:ew$qqGciDHA.4012@tk2msftngp13.phx.gbl...

> Hi,
>
>
> I'm using an access database and found following problem :
>
> I have a table X with 2 records : record 1 & record 2. I execute

following

> procedure with 2 steps :
> 1. The procedure deletes records 1 : connection.execute "delete from X
> record 1"
> 2. The procedure adds record 1 again using the recordset object.
>
> Result : nothing happens !
> I have the feeling that the "delete" statement is executed AFTER the "add
> record" statement. Or the "delete" statement did not finish before the
> start of the "add record" statement (= asyncrhonous processing).
>
> Can somebody explain me this behavior ?
> I have this problem only when using a MS Access database and not with an

MS

> SQL database.
>
> Jill
>
>

[Dan Brussee]

On Fri, 3 Oct 2003 17:15:36 +0200, "Jill Graham"
<jills_graham@yahoo.com.au> wrote:

>Hi,
>
>
>I'm using an access database and found following problem :
>
>I have a table X with 2 records : record 1 & record 2. I execute following
>procedure with 2 steps :
>1. The procedure deletes records 1 : connection.execute "delete from X
>record 1"
>2. The procedure adds record 1 again using the recordset object.
>
>Result : nothing happens !
>I have the feeling that the "delete" statement is executed AFTER the "add
>record" statement. Or the "delete" statement did not finish before the
>start of the "add record" statement (= asyncrhonous processing).
>
>Can somebody explain me this behavior ?
>I have this problem only when using a MS Access database and not with an MS
>SQL database.
>
>Jill
>

I think your going to have to explain this a little better. You say
you use Access, but also refer to a procedure. Is the Procedure
something in ASP?

Step 1: conn.execute "DELETE FROM X Where ID = 1"
Step 2: conn.execute "INSERT INTO X (a,b,c) VALUES (1,2,3)"

This kind of thing should work. The normal action of the connection
object is NOT asynchronous, so I doubt that is your problem.

When you say nothing happens, does the first record get deleted? Does
the new record not get added?

[Mark Schupp]

Show your code. The delete statement you list is not valid and you don't
show what your add record code looks like.

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Jill Graham" <jills_graham@yahoo.com.au> wrote in message
news:edO2dGciDHA.1048@TK2MSFTNGP11.phx.gbl...

> Hi,
>
>
> I'm using an access database and found following problem :
>
> I have a table X with 2 records : record 1 & record 2. I execute

following

> procedure with 2 steps :
> 1. The procedure deletes records 1 : connection.execute "delete from X
> record 1"
> 2. The procedure adds record 1 again using the recordset object.
>
> Result : nothing happens !
> I have the feeling that the "delete" statement is executed AFTER the "add
> record" statement. Or the "delete" statement did not finish before the
> start of the "add record" statement (= asyncrhonous processing).
>
> Can somebody explain me this behavior ?
> I have this problem only when using a MS Access database and not with an

MS

> SQL database.
>
> Jill
>
>

[Jill Graham]

Hi Dan,

Correct, this is a procedure in ASP

Table X has two records : ID = 1 and ID = 2

The procedure is as follows :
Step 1: conn.execute "DELETE FROM X Where ID = 1"
Step 2: rs.open "table X", <options>
rs.addNew
rs("ID") = 1
rs.update
rs.close

Result of the procedure : the record is deleted (step 1) but step 2 has no effect.

When I replace step 2 with following statement : conn.execute "INSERT INTO X (ID) VALUES (1)", then everything works fine.

Why doesn't the recordset work ?



"Dan Brussee" <dbrussee@NOSPAMnc.rr.com> wrote in message news:4h8rnv03hpvc5rjc4jfus49gifcmms43q3@4ax.com...

> On Fri, 3 Oct 2003 17:15:36 +0200, "Jill Graham"
> <jills_graham@yahoo.com.au> wrote:
>

> >Hi,
> >
> >
> >I'm using an access database and found following problem :
> >
> >I have a table X with 2 records : record 1 & record 2. I execute following
> >procedure with 2 steps :
> >1. The procedure deletes records 1 : connection.execute "delete from X
> >record 1"
> >2. The procedure adds record 1 again using the recordset object.
> >
> >Result : nothing happens !
> >I have the feeling that the "delete" statement is executed AFTER the "add
> >record" statement. Or the "delete" statement did not finish before the
> >start of the "add record" statement (= asyncrhonous processing).
> >
> >Can somebody explain me this behavior ?
> >I have this problem only when using a MS Access database and not with an MS
> >SQL database.
> >
> >Jill
> >

>
> I think your going to have to explain this a little better. You say
> you use Access, but also refer to a procedure. Is the Procedure
> something in ASP?
>
> Step 1: conn.execute "DELETE FROM X Where ID = 1"
> Step 2: conn.execute "INSERT INTO X (a,b,c) VALUES (1,2,3)"
>
> This kind of thing should work. The normal action of the connection
> object is NOT asynchronous, so I doubt that is your problem.
>
> When you say nothing happens, does the first record get deleted? Does
> the new record not get added?
>
>

[Ray at]

Is there an On Error Resume Next in your code? If not, what does your real
code look like?

Ray at work

"Jill Graham" <jills_Graham@yahoo.au.com> wrote in message
news:eSOJk7ciDHA.3204@TK2MSFTNGP11.phx.gbl...
Hi Dan,
Correct, this is a procedure in ASP
Table X has two records : ID = 1 and ID = 2
The procedure is as follows :
Step 1: conn.execute "DELETE FROM X Where ID = 1"
Step 2: rs.open "table X", <options>
rs.addNew
rs("ID") = 1
rs.update
rs.close
Result of the procedure : the record is deleted (step 1) but step 2 has no
effect.
When I replace step 2 with following statement : conn.execute "INSERT INTO X
(ID) VALUES (1)", then everything works fine.
Why doesn't the recordset work ?