470,590 Members | 2,556 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,590 developers. It's quick & easy.

connection.execute = asynchronous process ??

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
Jul 19 '05 #1
4 5186
Can you show your code?

Ray at work

"Jill Graham" <ji**********@yahoo.com.au> wrote in message
news:ew**************@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

Jul 19 '05 #2
On Fri, 3 Oct 2003 17:15:36 +0200, "Jill Graham"
<ji**********@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?
Jul 19 '05 #3
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" <db******@NOSPAMnc.rr.com> wrote in message news:4h********************************@4ax.com...
On Fri, 3 Oct 2003 17:15:36 +0200, "Jill Graham"
<ji**********@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?



Jul 19 '05 #4
Is there an On Error Resume Next in your code? If not, what does your real
code look like?

Ray at work

"Jill Graham" <ji**********@yahoo.au.com> wrote in message
news:eS**************@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 ?
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by JWM | last post: by
reply views Thread by Prodip Saha | last post: by
16 posts views Thread by crbd98 | last post: by
1 post views Thread by Jac | last post: by
2 posts views Thread by Nicolas Le Gland | last post: by
2 posts views Thread by Varangian | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.