Environment versions
Network:
Windows 2008 Server
>>Instead of trying to find which process has changed the workarea to an unused one (could be anything that selects into a cursor and then closes it without restoring the workarea on exit), why not just select the one you want immediately before the scatter command?
>
>I am glad that you and I think alike :). Yes, as soon as I found this error (which was in the program for a while and the customer(s) never reported it, until I found it in the error log), I added SELECT (AliasName), so in this specific place I won't see this problem.
>
>But I was wondering, in general, if there is another place in the program that could potentially cause a problem. I am trying to make my application completely error free :)
It might be more prudent to TRY... CATCH with original code in try and fix in catch - plus logging to show IF it was a spurious or regular error. Then you can decide if you need to follow the steps outlined in other post, but the program can carry on IAC.
my 0.02€
thomas
Previous
Next
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