>The connections are made trhough SQLSTRINGCONNECT. My problem is that when the error handler of the application fires I want to rollback all the transactions as well as change the transactions to automatic if they are set to Manual.Fabian,
I've a couple ideas off the top of my head.. You could place ON ERROR statements before each critical SQLEXEC to pass the connection handle to your error handler.
Alternatively you could set up one public connection handle variable that gets set to the current handle in use before each critical SQLEXEC and then have your error handler reference that global handle variable for its cleanup.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer