Jon, this are some pretty good Ideas, I can't really believe that Fox does not have something to track that.
Thanks a bunch.
Fabian
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only