Recordset Transaction

[charonlee]

hi,

just curious to know, Can the beginTrans work at Recordset level. As I found, all are done at connection, i.e:

BeginTrans
Con.Execute (SQL)
CommitTrans

can it be like that

BeginTrans
rs.Open SQL, con
if rs.oef then
display records
end if
CommitTrans

[macrost]

Hrmmm, I've never used BeginTrans before. Are you using a SQL server?
Mac

[daisho]

It depends on the Backend that you are using.

In most cases you can have many different transactions for one connection but they cannot be nested. Ie a rollback cannot undo a previous commit.

There may be exceptions but I use Oracle and also MySQL with Innodb tables and I've never seen behaviour different from this.