Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2003-05-13 : 02:56:15
|
| Hi Everybody,Sometime when I save data through my front end (ASP). The data in the parent table gets saved but the data in the sub table doesn't. This is Killing me. All the statements while saving the record is in con.begintransaction and con.committransaction. This make me confident that there cannot be a bug on the front end, because all the code is in transaction. Please throw some light on it.Thanks and RegardsSachin |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-13 : 07:27:06
|
| ADO transactions should never be considered as reliable as a regular SQL Server transaction. I would even suggest that you NEVER use ADO transactions, especially if the transaction only includes data operations. Rewrite your process to use a SQL Server stored procedure that accepts all of the parameters you need to perform the operation, then construct the transaction in the stored procedure. Then you can run it from ADO using one command call and all the transaction processing is done on the database server where it belongs. |
 |
|
|
|
|
|
Transaction problem