Hi,
I'm a newbit to PHP and I'm working on a project of online survey using Access.
I need to insert into several tables. How can I ensure that if insertion to 1 table fails, then all insertions be rolled back?
I tried to use odbc_autommit(), but it seems to give errors: the page just doens't come out. ANd when I get rid of the lines with odbc_autocommit(), it worked.
Does Access suppost transction? I checked Access help and it seems to support.
Who knows how to handle this?
Thanks in advance!
Sufeng
I'm a newbit to PHP and I'm working on a project of online survey using Access.
I need to insert into several tables. How can I ensure that if insertion to 1 table fails, then all insertions be rolled back?
I tried to use odbc_autommit(), but it seems to give errors: the page just doens't come out. ANd when I get rid of the lines with odbc_autocommit(), it worked.
Does Access suppost transction? I checked Access help and it seems to support.
Who knows how to handle this?
Thanks in advance!
Sufeng